Power BI Report freezes when clicking a visual

[Anonymous]

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?

[Anonymous · Accepted 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. 

[Anonymous]

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?

[Anonymous]

File will definitely help.  There's usually a reason why these things do the things they do :), just our job to figure that out