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 ...
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.
