Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Understand Incremental Refresh in Power BI Premium

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 

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

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. 

View solution in original post

Hi there,

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

6 REPLIES 6
kevhav
Continued Contributor
Continued Contributor

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
Not applicable

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. 

Hi there,

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

kevhav
Continued Contributor
Continued Contributor

I was also wondering about #3.

 

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

Anonymous
Not applicable

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...

 

Hi there,

I have not heard anything.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors