Forum Discussion
Improve Dashboard performance
I am working on a dashboard , combining different database. The dashboard takes time to refresh, tried removing the unwanted columns , but still it does takes time to refresh. Any idea to make it work much more faster ?
Hi Anonymous ,
external causes may be:
1.Network instability
2.If the slowdown is accidental or occurs at a specific time, there may be multiple users accessing dashboard at the same time.Internal causes of performance speed may be:
1.Too many visuals on the content page
2.Complex calculation logic, such as: measure, calculated column, RLS
In case of DQ/LC mode:A.The distance between data sources, gateway and PBI service may be too far (making the gateway delayed)
B.Data sources where the device is running at too low a rate, the query calculation is too complex lead to result in back-end data sources response time is too longOptimizing performance can be considered from the above perspectives and with the help of the following analysis tools.
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Anonymous , if you have bidirectional joins try to reduce those. Try 1 to Many single direction join
- Fowmy
Anonymous
In addition to amitchandak point, please check the following as well. There could be multiple reasons for slow performance. it could be your model ( cardinality, database size, column count etc ) , DAX measures , number of visuals, and so on. 
v-henryk-mstfCommunity Support
Hi Anonymous ,
external causes may be:
1.Network instability
2.If the slowdown is accidental or occurs at a specific time, there may be multiple users accessing dashboard at the same time.Internal causes of performance speed may be:
1.Too many visuals on the content page
2.Complex calculation logic, such as: measure, calculated column, RLS
In case of DQ/LC mode:A.The distance between data sources, gateway and PBI service may be too far (making the gateway delayed)
B.Data sources where the device is running at too low a rate, the query calculation is too complex lead to result in back-end data sources response time is too longOptimizing performance can be considered from the above perspectives and with the help of the following analysis tools.
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
