Wanna stop download preview in Power Query

[AnkitSingla]

Hello All,

I am using Power BI October,2021 release.

I don't wnat to download the preview in Power Query.

To achieve it, i have used settings as below: 

However, it still downloads the preview as below:

Any help would be highly appreciated.

[Ehren]

Unselecting the background data setting just means that previews will be computed on demand, whenever you select a given query/step, instead of being computed in the background for all queries/steps.

[AnkitSingla]

Hello @Ehren Is there a way to stop downloading the preview unless user explicitliy refresh the preview?

[Ehren]

No, there isn't. Can you describe your scenario a bit more? I'm curious why you're wanting this behavior.

[AnkitSingla]

Hello @Ehren, Someone from team accidently deleted the data from datasource (dataverse). 

As i have not refreshed the data since last week, just wanted to get the same. As preview gets downloaded, not able to get the data(without transformation).

[Ehren]

Hm. I'm not sure there's much you can do in that case. Your options would be:

• Re-populate the data source
• Temporarily point your queries at a different source that has the same schema