Report builder doesn't show all the records

[Anonymous]

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.

[FHodali]

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 

[sam_1999]

Worked perfectly, thank you!

[jana_powerbi]

This is exactly what I was after! Thanks

[v-kelly-msft]

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!