Data previews in background checkbox greyed out

[monojchakrab]

Hiya all,

I am having this problem with power query and BI both - forcing me manually refresh numerous queries every time I fire up the engine.

The fact that I am using a data source from my organizational onedrive folder is also not helping as every refresh - literally every step of every query is taking enormous amount of time

Is there any help around with this and is there any method to make the refresh faster?

Thanking in anticipation

[AnisAloyseNaim]

Hello 

Same here. I don't have access to allow or not

I would sign more for an issue in lastest desktop version...

and in PowerQuery from time to time i have 

[AnisAloyseNaim]

Hi 

I wonder if this is not the same weird mechanism oaround the power query preview refresh 

https://community.fabric.microsoft.com/t5/Desktop/Report-not-refreshing-due-to-the-Power-Query-Data-...

Maybet with from recent PowerBI Desktop update ? 🤔

[monojchakrab]

thanks @ppm1 

[ppm1]

Not sure why that is greyed out, but FYI that you can set up incremental refresh to speed up refresh for your published dataset. While you are developing, a good tip is to do Keep Top Rows to limit it to 1-3 files temporarily. Once done, just remove that step to load all files.

Incremental Refresh with SharePoint Files - YouTube

Pat

[monojchakrab]

Thanks @ppm1. Does this require a premium or pro BI license?

[ppm1 · Accepted solution]

Works in pro. 

Pat

[gvlado]

You probbly have checked "Always allow data previews to download in the backround" in Options / Global / Data Load
I recommend Allow data preview to download in the background according to each file settings