OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D

  • OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D

    Posted by Unknown Member on March 4, 2021 at 11:16 am
    • Adam Ishak

      Member

      March 4, 2021 at 11:16 AM

      Hi All,Ā 

      Ā 

      Anyone know what this error details, the only change I have made to my SQL views is adding 1 Column. Im using 3 appended viewsĀ 

      aishak12_0-1614722846549.png

      ——————————
      Adam Ishak
      Data Analyst
      Parsippany NJ
      ——————————

    • Syed Jafri

      Member

      March 4, 2021 at 12:02 PM

      Go to Data Model, refresh preview of the query and then apply changes. Make sure no errors in the query, sometime change of datatype in source conflict with query column data type especially date columns.

      ——————————
      Syed Jafri
      ——————————
      ——————————————-

    • Olivier LN

      Member

      March 5, 2021 at 2:12 AM

      Hi,
      It happens to me. Once with issue in special characters.
      Database was not managing the characters and create a strange encoding. when power BI was loading it fails with this message.
      Best
      Oln

      ——————————
      Olivier LN
      92120
      ——————————
      ——————————————-

    Unknown Member replied 4 years, 6 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!