External SharePoint Connection Not Importing Data

[Anonymous]

I have a connector established to an external customer's SharePoint page with approved credentials but am facing a weird refresh issue.

Context

The client runs and disseminates excel data reports to SharePoint. Initially these files were being imported to a master excel file that created reports. As part of automation we're establishing a PowerBI connection to consume the data reports and produce desired visuals.

Issue

A sharepoint connector has been established to import files, but many of these files are coming through with only the column headers. The data itself is missing. Initially, I have found that unless a file has been opened at least once (by any user) the file will come through as column headers only. Once the file has been accessed by a user, the data populates.

I'm unsure if this is a PowerBI specific issue or a SharePoint issue, but any advice would be much appreciated.

[Anonymous]

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.