Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Erro do OLE DB ou do ODBC : [DataSource.Error] Microsoft SQL

Hi All , I'm facing a data refresh error after update my PBI Desktop, now its showing the erros below in two tables that I have (in the old version this issue doesnt occu.  When I edit the queries the errors are not showed and it seems to be some record in the database that can be causing the error.

 

Does anybody know how can I debug this or know how to fix it?

 

"Erro do OLE DB ou do ODBC : Exceção de HRESULT: 0x80040E4E"

"Erro do OLE DB ou do ODBC : [DataSource.Error] Microsoft SQL: Incorrect syntax near the keyword 'union'"
 
thanks a lot.
Need Help

10 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    5 years ago

    Hi Anonymous ,

     

    do you use pure Power Query or SQL queries?

    UNION indicates that a query is being appended. Do you have a corresponding query?

    You can use tools such as the SQL Profiler to trace the query on the database.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi mwegener , I've noticed that the querie that is showing problem is a combined querie, it always show error when it reaches line 4096 in the update process.  During the process, when it reachs linhe 4096 it restart the counting and the error is showed.  Any tips?

       

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        5 years ago

        Hi Anonymous ,

         

        Try the following steps for more information.

        Expand the Column Profile in the lower left corner of Power Query.

         

        See if you can get the native query from the query.