Forum Discussion
There was an error when processing the data in the dataset.
Solved the issue.
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.
Solved the issue.
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 Jason299
Hope you are doing well.
I am facing the same issue in my PBI Service.
I am using one report where i have 2 data source(SAP HANA and Sharepoint folder-file is in csv). As you suggested i tired the same and copy pasted the data in new workbook and saved in .xlsx format and changed the file in query editor however i am still getting the same issue.
Is there anything you can suggest ? Please see below error message
Thanks ,
Ashish