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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Farol
Frequent Visitor

Incremental refresh parametes are not seen in the service settings

Hey! I have PowerBI dataset and trying to set up an incremental refresh to it.

I did everything exactly how it is explained here https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure#filter-data

and in this thread https://community.fabric.microsoft.com/t5/Desktop/Incremental-Refresh-RangeStart-vs-RangeEnd-Paramet...

 

What's confusing that my RangeStart and RangeEnd parameters are not seen in the settings tab

Farol_0-1687554633148.png

 

Is there any other indication that my incremental refresh is set up and works?
Based on the speed changes/improvements, I don't think so.

If it is not working - why?

4 REPLIES 4
gauthamboppana
Solution Specialist
Solution Specialist

@Farol  - The incremental refresh parameters are deifned  in the power bi desktop (.pbix file).  Basically, the dataset refresh in power bi service uses the same parameters set up in the dekstop. They are not set up separately in the Power BI Service. 

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

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you @gauthamboppana ! That is clear and that is what I did. The question is - should I see those parameters in the Service when it is all set? And how can I make sure it's all set up properly, incremental refresh is working?

Once you configure incremental refresh, the service manages those parameters so you won't see them. If you had other parameters, you would see those. If your dataset is published to a workspace back by Premium (or PPU), you could connect with Tabular Editor or SSMS to the XMLA endpoint to see your partitions (and last refreshed datetime). If not, you should notice a much faster refresh time in the refresh history. The first one after publish will be all partitions, but the subsequent ones should be much faster.

 

Pat

Microsoft Employee

@Farol  - Unfortunately, you will not see these paramters in Power BI Service.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors