Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Optimizing reports

Hello , 
I am using a large amount of Data and I need my report to be fast when published for the end user in the powerbi Service , the model and the DAX formulas are optimized ,  I wanna know if there are  other optimization techniques to use so the report in the PowerBi service is smooth and fast . (I have premium capacity ) 
Thanks . 

1 ACCEPTED SOLUTION
Brunner_BI
Super User
Super User

You can try to remove all unused columns and measures with tools like Measure Killer. Not sure if that is an option for you.

How long does everything load now? You can turn on advanced features like auto aggregations etc. in the Power BI Service as well.

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog

View solution in original post

1 REPLY 1
Brunner_BI
Super User
Super User

You can try to remove all unused columns and measures with tools like Measure Killer. Not sure if that is an option for you.

How long does everything load now? You can turn on advanced features like auto aggregations etc. in the Power BI Service as well.

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.