This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hello Team,
We have excel as source for our Power BI dashboard.When we pusblish the file in the server and try to view them but visual are taking 2 minutes to load. Even after the load to retive data as per slicer seleciton it's also slow.
Can you please suggest some thoughts to improve the performance.
Regards,
Narender.
Solved! Go to Solution.
Thank you lbendlin
Hi, @tangutoori
To improve performance, I recommend that you consider the following:
With Power BI's query parallelization feature, you can dramatically improve dataset performance in DirectQuery mode. This means that multiple queries can be processed at the same time, resulting in faster loads.
By following some best practices and optimizing your data model to reduce unnecessary columns and rows, you can improve the responsiveness of your reports.
Using Power BI's Performance Analyzer tool, you can identify which visuals or DAX formulas are causing performance bottlenecks so you can make targeted optimizations.
Optimization guide for Power BI - Power BI | Microsoft Learn
Boost Power BI Efficiency with DAX Optimizer - SQLBI
Introducing the Power BI Performance Analyzer - SQLBI
If you're using card visuals in your reports, make sure they're designed to be clean and avoid too many complex calculations, which can reduce load times.
Optimizing card visuals in slow Power BI reports - SQLBI
Optimizing DAX expressions involving multiple measures - SQLBI
These methods can help you improve the loading performance of your reports.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you lbendlin
Hi, @tangutoori
To improve performance, I recommend that you consider the following:
With Power BI's query parallelization feature, you can dramatically improve dataset performance in DirectQuery mode. This means that multiple queries can be processed at the same time, resulting in faster loads.
By following some best practices and optimizing your data model to reduce unnecessary columns and rows, you can improve the responsiveness of your reports.
Using Power BI's Performance Analyzer tool, you can identify which visuals or DAX formulas are causing performance bottlenecks so you can make targeted optimizations.
Optimization guide for Power BI - Power BI | Microsoft Learn
Boost Power BI Efficiency with DAX Optimizer - SQLBI
Introducing the Power BI Performance Analyzer - SQLBI
If you're using card visuals in your reports, make sure they're designed to be clean and avoid too many complex calculations, which can reduce load times.
Optimizing card visuals in slow Power BI reports - SQLBI
Optimizing DAX expressions involving multiple measures - SQLBI
These methods can help you improve the loading performance of your reports.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sounds like your report server is underpowered or has a bad network connection? What are the characteristics of the machine?
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |