Forum Discussion
Power BI directquery performance
We have requirement to do real time reporting from SQL server. We are having performance issues with direct query mode - its extreamly slow.
Scenario:
We have visualizations with multiple level of drill up/down (hierarchical structure) - we are using DAX to build measure - what we found is that PBI is sending multiple queries to data store (SQL server) one for each level in hierarchy (no matter what operations is done on drill down). We optimized each SQL but looks like PBI fires these SQL's in sequential way and not in parallel. Is there a way in PBI:
1) PBI pulls data at lowest level in report and do aggregation in PBI (direct query)
2) Fire SQLs in parallel rather than sequential.
Hi Anonymous ,
For your scenario, I'm afraid that there are many factors will affact the performance when we use direct query in Power BI.
Please have a good look at this document about directquery best practices and do some modifications to get the best performance.
Best Regards,
Cherry
Hi Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
2 Replies
Hi Anonymous ,
For your scenario, I'm afraid that there are many factors will affact the performance when we use direct query in Power BI.
Please have a good look at this document about directquery best practices and do some modifications to get the best performance.
Best Regards,
Cherry
Hi Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry