topic Re: Selective refresh in power bi? in Developer

Selective refresh in power bi?

hxkresl — Sun, 07 May 2017 04:31:20 GMT

Possible to refresh certains tables and not others?

In my dataset, only a couple of tables need regular refreshing, while the rest are look up types. Trying to get real time reports...but overhead of refreshing all look up tables means 8 minute refresh instead of 4 min...

Re: Selective refresh in power bi?

Greg_Deckler — Sun, 07 May 2017 13:58:05 GMT

You can set whether a query refreshes or not. Go into Query Editor and select whether load is enabled and whether it is included in refresh.

Re: Selective refresh in power bi?

hxkresl — Sun, 07 May 2017 17:43:41 GMT

1. could you pls provide a screenshot of where this is done and maybe couple directional steps? thanks in advance.

Re: Selective refresh in power bi?

Eric_Zhang — Mon, 08 May 2017 09:17:08 GMT

hxkresl wrote:

1. could you pls provide a screenshot of where this is done and maybe couple directional steps? thanks in advance.

hxkresl

I think Greg_Deckler is talking about

When "Include in report refresh" is unchecked, the query won't refresh when clicking "refresh" in Power BI Desktop. However this functionality won't work after you publish your report to Power BI service.

At this moment, there's no workaround for your question, you can check the similar ideas listed, add comments and vote them up.

Extend "Include In Report Refresh" Further

Incremental Data Loads