Forum Discussion

Jason299's avatar
Jason299
Frequent Visitor
7 years ago
Solved

There was an error when processing the data in the dataset.

i have several reports pulling data from a sharepoint and for some reason I have 1 report that worked yesterday but today will not refresh online.  When I go into the desktop version it will update w...
Need Help
  • Jason299's avatar
    Jason299
    7 years ago

    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.  

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
7 years ago
Hi there I would suggest that on the server where your On-Premise Data Gateway is running you ensure that the 'Microsoft.ACE.OLEDB.12.0' 64bit driver is installed as suggested via the associated link. That appears to be why it refreshes on your Power BI desktop, but not via the Gateway
Jason299's avatar
Jason299
Frequent Visitor
7 years ago

The data is from a sharepoint so there is no gateway needed or used.  there are several other reports running on the power bi site from the same sharepoint.

 

Any other ideas?