cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vdaga
New Member

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

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 

2 REPLIES 2
v-frfei-msft
Community Support
Community Support

Hi @vdaga,

 

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Hi @vdaga,

 

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


Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors