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 th...
Need Help
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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi mwegener , I've noticed that this joined querie shows the error below in all collums when I set profile to show all data and a red line is also displayed, when the profile is set to first 1000 lines the error is not showed.

     

    I got the native querie but it is too long to past here, but I don't believe that is a querie problem because it works for the first 1000 lines and worked in previes release of PBI Desktop that I was using before update to the last release.  Coud it be a problem in this release with the resource below that was used to join two tables?

    Thanks a lot.

     

     

     

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

      Hi Anonymous ,

       

      have you tried the Power BI Desktop September release?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        mwegener , I was using August Release, but I updated to september and the same issue is happening.

         

        thanks.