Forum Discussion
monojchakrab
Resolver III
Resolver IIIData previews in background checkbox greyed out
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 org...
Works in pro.
Pat
ppm1
Solution Sage
Solution SageNot 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
monojchakrabThanks ppm1. Does this require a premium or pro BI license?
