Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
110
Views
Topic starter
Hi.
If I edit a Query, the refresh imports the millions of rows of data again (time consuming !!). It does get quite tedious when developing a model and reports. Is there a way of avoiding this?
Regards.
Tony
Posted : 04/04/2017 4:34 pm
Hi Tony,
There's no way to disable a query refresh, other than to close the query editor with the 'x' in the top right of the window and choose 'Discard' changes.
I guess if you're editing a query then it makes sense that you'll want your changes to be reflected in the data, whether that be in the worksheet or data model.
If you're loading your data to the data model (Power Pivot) then you can disable the refresh of any PivotTables attached to this model with this tool:
https://olappivottableextend.codeplex.com/releases/view/618637
Mynda
Posted : 04/04/2017 8:49 pm
