Forum Discussion
Report builder doesn't show all the records
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...
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
Worked perfectly, thank you!