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?

 

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

This seems to be an error in the SQL query in the database. You can check the data source in the database.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-lionel-msft , the querie works for the first 1000 lines, I believe that this querie is constructed by the joined querie PBI resource, and the original tables that compose this joined table doesnt show the error, neither when a set the profile to show all data.

     

    best regards;