Question: how to import sharepoint data into power bi?
Answer: In the Power BI Desktop app, click the Get Data drop-down menu located in the External Data section of the ribbon and select More. ... 
Scroll down and choose SharePoint Folder, as shown in the following figure. ... 
Click Connect.
Click OK to connect.