Forum Discussion

PowerBI123456's avatar
PowerBI123456
Post Partisan
5 years ago

Dimension Table

Hi - Need some tips/advice on the model I am working on. Its pretty complex with a lot tables and some of my fact tables have 20 million +rows.  When creating my visualizations, is it better (perform...
Need Help
Show and Tell
Tips and Tricks
pc2's avatar
pc2
Helper I
5 years ago

Yes, it should improve the performance... try it and see.

 

I would create a dynamic table based off your fact table, create a New Table, = distinct(FactTable[columnName]).  Then create the relationship with the FactTable.

 

Also, use the "Performance Analyzer" under View menu to test the performance.