Forum Discussion
Refresh error when pbix file saved on SharePoint Online
I hae a pbix file which has been saved on a file share for a while. It connects to 3 data sources (SQL Server, A csv file stored on SharePoint Online and a SharePoint Online list). Everything was working great, but to handover the running of the report I need to store the report somewhere else - on SharePoint Online (the same subsite as the 2 SharePoint sources mentioned above)
I moved the pbix file to SharePoint Online, and attempted to refresh the data, but got the following error message:
The data source with the problem is the csv file stored in SHarePoint Online.
My organisation has our SharePoint Online tenancy as a trusted site.
I'm not seeing, within the data source settings, an option to select "login automatically".
Neither I or my IT department are able to get past this error message, can anybody help?
2 Replies
v-juanli-msftCommunity Support
Hi Anonymous
First uncheck the option below
Check which data source can refresh successfully.
Then please let me know what is the bottom item you hide.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.cvv
- v-juanli-msft
Hi Anonymous
I test on my side with the three kinds of data sources.
When i upload the pbix to Sharepoint, to open it on Sharepoint, i need to download it locally, then i open the pbix and click on "refresh", it works on my side.
What's difference with mine for your scenario?
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.