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
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.