Forum Discussion
There was an error when processing the data in the dataset
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
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.
1 Reply
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.