Forum Discussion
External SharePoint Connection Not Importing Data
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.
1 Reply
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:
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.