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

      • LudFel's avatar
        LudFel
        New Member
        5 years ago

        I had a similar error, and managed to fix it, deleting the duplicate lines.
        For some reason when you have a column with duplicate values ​​the error occurred.