Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there a recommanded solution to manage more than 1 Million rows in Direct Query mode?
Requiremnt:
The table in the report should show only 999999 rows of data, at the same time the table should alllow users to sort the data based on any column.
Solved! Go to Solution.
Hi,
Add slicers and filters to limit the data on the visual.
Thanks
Hari
Hi,
Add slicers and filters to limit the data on the visual.
Thanks
Hari
@Anonymous , when your query is run against database max result it can bring to power bi i 1 M rows , if it is more than that you will face this issue. Limit your visual for a number of rows, do not use line level field. Avoid bi-directional join
Also, check the measures for a few row-level context calculations.
Or share the measure in the visual
@amitchandak I have only one table visual on the report page which is working as a drill through the page. The table is using 5 direct columns from the Azure Analysis Cube and 2 aggregation measures(again from cube).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |