Forum Discussion
Exporting issue, only 2500 rows exporting
I am new to Power BI and am struggling to understand why I am only getting 2500 rows of data to export, either through Power BI desktop or through POwer BI web. My report is only 7100 rows in size...
JenniferL , Does your visual have 7000 rows, Power BI aggregates data at the visual level,
Can you count rows at a visual level using
Countrows(Summarize(Fact, Dim[Col], Dim2[Col], "_1",[Measure]))
All all measure and columns(group bys) and check number
or add rownumber and check
New DAX Function: Rownumber- https://www.youtube.com/watch?v=yS9-IQjUDwg&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=1
Sort desc on rownumber and check