There was an error when processing the data in the dataset

[mumin]

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

[v-diye-msft · Accepted 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.