Data Preview - Memory Issue

[QS7]

Hi everyone,

We are currently encountering an issue with the data preview of Power Query.

The issue is that each time that i click on the request to change the Power Query, the data preview is starting, when i add filters on my data source ( SAP HANA ), a preview is starting, etc ...
This is fine as long as the request are not heavy, but some of our request use a lot of memory and navigating through the Power Query editor is enough to start 4/5 previews that use all the available memory in HANA.

-> I tried to disable those preview, it seems that it is not possible yet 

Does someone know how to deal with this issue ?

Thanks.

[edhans]

Have you tried changing the data load settings? Shown are the global settings. You might also need to tweak the local settings for that file. Global settings are in effect for new files, or if that particular setting doesn't exist in the Local settings area.

 

[QS7]

Hi edhans,

If i'm not mistaken this option just means that the preview will be processed when i select a query or a step in the Power Query Editor instead of being processed for all of them in background.

My issue is that i need to stop any kind of preview because otherwise during the modification of the Power Query the previews requests are send to our database ( And not killed when we swap between the steps ), and this is consuming all the available memory.

[edhans]

You cannot stop the preview. If you click on it, it will preview. If you want to code with no preview, copy the existing code to NotePad++ and work from there, then paste it back.

Or get a copy of the database (limited copy with just the necessary tables) and put it in a DEV environment. This is one of the purposes of a dev environment. You could even replicate the tables to a Dataflow, work from those, then change the connector later to go back to the SAP database when done.