Forum Discussion

InsureBI's avatar
InsureBI
Advocate II
10 years ago

Data refresh error: OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D.

I am trying to refresh a table (with less than 50 records and 200 columns).  The source is a text file on my desktop and I am pretty sure nothing has changed except a few additional records in the ne...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I have made a work around for this issue.  It seems there is an issue going from the SharePoint cloud with an .xlsx file to Power Bi.

 

  • We made a folder, with the excel file in it, in a network drive and set up a data gateway in power bi directly to that file. 
  • In Power Bi Desktop you use the same file to generate your report and publish it while making sure to all page and report level filters you would like to that report.
  • After publishing go into the settings of that data set and add that gateway to it. 
  • This will allow you to update the background data and the report will update with that data.

I hope this helps.