Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 q...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

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's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous,

     

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


    Regards,
    Frank