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.
Hi People
I'm encountering this error while displaying my visual. Seems like error show only when I do select all.
Maybe my DAX measures are too much for system to handle it. Any other way to code the dax below? I'm using date intelligent for KPI.
Measure 1
Hi @Anonymous
As the info prompted in the tab header, "The query is too large, consider removing unused columns, add visual filters, or reducing the number of string type columns."
Please check Note of this article:If a table has too many values, consider converting it to a matrix and/or using drilldown. The maximum data points a table will display is 3,500.Here are some tips about Power BI performance for your reference.
I'd suggest creating views of the SQL Server tables used in the report. The views restricted the number of rows and columns considerably. We can used these views as the datasources for the report and it refreshes online without any issues.
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 |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |