Forum Discussion
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 know if IBM Db2 limits the rows we can import ?
I created a SQL connexion to import the data and I make a filter on a date column in the SQL query.
If I filter on Year>2010 for example, I don't have the 2021/2022/2023 data but if I filter on Year>2015, I have these
I would like to have all the data since 2010
Thanks
6 Replies
Hi Anonymous
It may be affected by the Data caching.You can try to clear the permission and reconnect the sql again, you can refer to the following link to clear the permission.
Then try to connect the sql again.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- edhans
Community Champion
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.
