cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sicilian Member
Member

Incremental refresh with Power BI premium report

Hi all,

 

I've watched several good blogs and videos on configuring incremental refresh for reports published to a premium capacity workspace. We do have premium, as well as a data warehouse which has an audit column on each dimension/fact table that has the last processed/updated date time. 

 

I'm not sure what values to set my RangeStart and RangeEnd parameters to by default. I know the filter will be on the last process date column to be between the RangeStart/RangeEnd parameters. Essentially it should check to ensure the process date time is greater than the last time it was loaded, so it only loads the records daily.

 

 

Capture.PNG

 

Alos, when using Azure SQL database with import, I don't think there is a way to refresh more frequently than daily is there?

 

Is it typical to only apply incremental to the fact table? Wouldn't it be ideal to set all tables to incremental?

1 REPLY 1
v-cherch-msft Super Contributor
Super Contributor

Re: Incremental refresh with Power BI premium report

Hi @Sicilian 

 

Please check if this post could help you.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 364 members 3,524 guests
Please welcome our newest community members: