Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Rows limit with IBM Db2 connexion

Hi, I had a report with an ODBC connexion and everything was OK but we had to change the connexion type to a IBM Db2 connexion When I use this type, I don't have all the rows I should have Do you ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    FinallyI found the error, it was because of a LEFT JOIN

    I don't understand why a left join delete rows of the first table but I could fix it

     

    Thanks for your help

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
2 years ago

Can you post your M code? There is no reason it would work in one dataset and not another unless you are connecting with different permissions or there is another setting (a timeout perhaps) that is set different.

 

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

I thought about a timeout issue. Do you know if we can change this setting ?

I will send my M code later maybe, I don't have it today

 

Thanks

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Often you can change it in the original connection to the database in the Advanced Properties. If not, you could talk to your DBA about increasing the timeout on their end. You might also have them run a query trace and see why it is truncating the extract. They will be able  to see exactly what is happening on the server.