Disble triggering multiple queries when selecting dimensions/measure in direct query mode

[Anonymous]

Hi,

I have been using the direct query mode in Power BI with snowflake as the database. I am facing the problem where, as I select different measures and dimensions from a table, it sends a new query to the database re-selecting the the measures/dimensions already in the report. For example - I select a client_id from the table - the query that goes to the backend is - Select client_id from table. Now if I select a different measure like order amount, it sends - select client_id, sum(order_amount). If I have 20 columns in there, this process is highly inefficient. Is this the way it has been designed or is it possible for me to disable it or only run queries on demand, like me selecting everything and then applying or something like that?

Thanks,

Varun 

[v-frfei-msft]

Hi @Anonymous,

This is by design, as you create or interact with a visualization, Power BI Desktop queries the underlying data source, which means you’re always viewing current data.

Many data modeling and data transformations are available when using DirectQuery, though with some limitations. When creating or interacting with a visualization, the underlying source must be queried and the time necessary to refresh the visualization is dependent on the performance of the underlying data source. 

For more details, please check the online document.

Regards,

Frank

[v-frfei-msft]

Hi @Anonymous,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank