Power BI directquery performance

[Anonymous]

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. 

[v-piga-msft · Accepted solution]

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

[v-piga-msft · Accepted solution]

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

[v-piga-msft · Accepted solution]

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