Understand Incremental Refresh in Power BI Premium

[Anonymous]

Hi All ,

I want to better understand Incremental refresh made recently available as preview feature in May 2018 release for Power BI Premium though. 

I have few questions  before I start applying incremental refresh on existing datasets - 

1. Can we have more than 1 table with Incremental refresh policy in single dataset ?
2. Can mandatory RangeStart / RangeEnd Parameters be re-used for other tables ?
3. How to force full refresh on a table with incremental policy once we publish a report/dateset ?

Many Thanks,

Nilesh 

[Anonymous · Accepted solution]

I tried with sample report for #1 and #2 ,  We can have refresh policy on multiple tables by using same Range parameters. 

For #3 , there no option available in Power BI service except to re-publish model itself. 

[kevhav]

For #3, forcing a "full refresh" on a dataset that has one or more incremental refresh policies...

I posted this as an idea, here. Please vote it up.

[Anonymous · Accepted solution]

I tried with sample report for #1 and #2 ,  We can have refresh policy on multiple tables by using same Range parameters. 

For #3 , there no option available in Power BI service except to re-publish model itself. 

[GilbertQ · Accepted solution]

Hi there,

#3 is something that they are working on getting added.

[kevhav]

I was also wondering about #3.

@GilbertQ, how do you know they are working on this? Anyone heard any ETA?

[Anonymous]

With XMLA Endpoints announced recently , we should be able to achieve #3 programmatic way.

https://docs.microsoft.com/en-us/business-applications-release-notes/october18/intelligence-platform...

[GilbertQ]

Hi there,

I have not heard anything.