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
6 years ago

Hello,

I came acroos this same error yesterday in one of my PBI reports.  I tried a lot of the suggetions I came across pn this forum, but none seem to work.  I just pyulling in a notes Excel spreadsheet into my PBI.  Wierd thing is my co worker can open the file and refresh just fine.  Anyone have this issue or know anythign about it?

 

Im getting this error: OLE DB or ODBC erro: the handle is invalid.. A connection could not be made to the data source with the name of '675abf08-3e93-4158-ae32-23f0fd4b3f4d

  • lrACN's avatar
    lrACN
    Frequent Visitor
    6 years ago

    Hello, I got the same code reference some seconds after I launched the "Refresh All".

     

    After reading all the previous posts and doing a lot of attempt I discovered I solved by isolating and unflagging one specific "preview feature" among the Options:

     

    "Store datasets using enhanced metadata format."

     

    Now, without that option, my repor works perfectly as before the latest PBI Desktop update.

     

    I read on the guide of the feature that PBI is investing on this feature for future release, and the fact it is not working on my project makes me fear I will have many problems in feature. I hope PBI engineers will fix this collateral effects (I thing it is RAM related, because I saw in the task manager that the process is really RAM-demanding if the option is active, till the crash happens).

     

    Hope this can be useful for people not having solved still.

     

    Thank you everybody for all suggestions.