Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
I have a report which has many data sources some linked to sharepoint folder (folders with excel files inside) and some to web links to a direct excel file online
In the desktop version, I was able to refresh the data
when I published it, and tried to refresh, it showed me this error, probaly from the sharepoint folder
Any help please?
Thanks
Solved! Go to Solution.
Hi @mumin
The Scenario
Have a Excel file saved to a sharepoint. This is where Power BI is pulling the auto updates from. When accessing the file it opens in Excel online. If you make any updates on here it was changing the version of the Excel file causing the error.
Fix.
Copy and paste the data to a blank Excel file to make sure its the proper version. You can save it over the original or in a new location. If in new location you have to change the path in the query editor.
Make sure not to work in Excel online always open in Excel for this issue.
Hi @mumin
The Scenario
Have a Excel file saved to a sharepoint. This is where Power BI is pulling the auto updates from. When accessing the file it opens in Excel online. If you make any updates on here it was changing the version of the Excel file causing the error.
Fix.
Copy and paste the data to a blank Excel file to make sure its the proper version. You can save it over the original or in a new location. If in new location you have to change the path in the query editor.
Make sure not to work in Excel online always open in Excel for this issue.