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.
I built a report that is looking at a large data set from multiple tables, and when I click the visual it sometimes takes up to 5 minutes for it to even register letting me click anything with PowerBI. Is there someway to optomize this to load better?
Solved! Go to Solution.
there are quite a few things that could be hanging this up. The first thing I'd look at is the Data Model? Are your filters in the visualization coming from dimension tables? Or are you filtering the actaul fact table? Is it star schema or even snowflake? From there you I would look at cardinality ( unique values) of each column. Then I'd see if there was a better way to write the measures.
there are quite a few things that could be hanging this up. The first thing I'd look at is the Data Model? Are your filters in the visualization coming from dimension tables? Or are you filtering the actaul fact table? Is it star schema or even snowflake? From there you I would look at cardinality ( unique values) of each column. Then I'd see if there was a better way to write the measures.
To be honest, im not sure the differences? Im not an expert, but I have created several reports using the same data, and none of my other reports freeze like this one does. I'd be happy to attach the file if that helps?
File will definitely help. There's usually a reason why these things do the things they do :), just our job to figure that out
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |