Forum Discussion

RKM's avatar
RKM
Icon for Helper IV rankHelper IV
4 years ago

Directquery Performance And Each visual executing query in SQL Server - Any ways to improve?

I want to understand this scenario a little better from you experts... I have a simple dashboard with 3 tables. 2 out of those 3 are hardcoded value tables [Enter Data in Power Bi] and having 4 and ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi RKM ,

 

In DirectQuery, whenever you click something in the report, a query is sent to the underlying data source. If you change a slicer, there will be sent a new query for every visual on the current page. You click on a bar on the bar chart, all the visuals send a query to the data source. You deselect the bar chart, all visuals send again a query to the data source.

 

Best Regards,

Jay