This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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 April 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 |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 2 |