The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
20 | |
19 | |
15 | |
13 |