During the design of a visualization, pause the visualization from querying the database while you add dimensions and measures to the visualization. I am working with a very large dataset, so when I drag out a dimension or a measure, it's refreshing it eachtime. Let me pause that, drag out the whole design, and then refresh it.
5 Comments
- Very much agree with this request. When using DirectQuery connector (we are specifically interested in HANA), having repeated queries triggered to the back end as I'm adding dimensions & key figures to a visual means memory usage is consumed rapidly and memory thresholds are quickly reached. There is no way to cancel a query and no way to pause, meaning an inefficient query processing. Other tools (example: SAP Analysis for Office) have a specific 'pause' option, allowing the user to build their crosstab/visualisation structure with all required fields before unpausing and running the query in one hit. Can Microsoft consider a 'pause/unpause' for PowerBI desktop and service? Thanks.
- Completely agree, this is *the* fucking productivity killer. Designers should be given the option NOT to refresh.
- Tableau has this feature and it is GREAT! Please implement!
- It is a must especially since Power BI seems to use a lot more RAM since the fall 2019 releases. Slightly better when authoring from a VM, but still it's a pain when you waste 15 minutes updating 3 graphs...
- Status added:Needs Votes
