External SharePoint Connection Not Importing Data

Hi Anonymous ,

What connector you use? After the file has been accessed by a user,has this error ever occurred?

I have also found a similar post, please refer to it to see if it helps you.

Solved: Empty Folder-Structure on get data from Sharepoint... - Microsoft Power BI Community

• Try using the Web connector (enter the full path, ending with .xlsx).

• See if this helps:

  https://ssbipolar.com/2018/10/29/power-query-connecting-to-excel-workbooks-in-sharepoint-online/ 

You could refer to below blog for detailed description:

Combining Excel Files hosted on a SharePoint folder with Power BI | Microsoft Power BI Blog | Microsoft Power BI

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.