Forum Discussion

mumin's avatar
mumin
New Member
6 years ago
Solved

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 wa...
Refresh dataset
sharepoint Folder
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    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.  

     

     

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

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.