Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to create the paginated report from the power bi report. For that, what I do is copy the dax query of the table visual from the performance analyzer and paste it to create a table in query in report builder. The issue is that power bi shows foe example, 900 rows then same report in report builder shows only 500 records of that report. Is there any limitation of number of reows to display? or what am I doing wrong? Please help. Thanks.
I have the same issue, I found that DAX limits the rows when you copy the query to around 500 rows, the solution is to change the number for example to 999999
VAR __DS0PrimaryWindowed =
TOPN(
999999,
__DS0Core
This will solve the issue and bring all data,
Fadi Hodali
Hi @Anonymous ,
I havent found such limitations after checking reference,see the related vedio below to check whether you have got the query correctly.
https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-shared-datasets
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!