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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
adeeln
Post Patron
Post Patron

Need help for the clarification of Incremental refresh .

I have some questions according to the Incremental refresh. Please give me their answers with an example.

Question 1. Why date should be static(Order date, transaction date) in which we applied Incremental refresh ranges (start and end ranges ) ??.

Question 2.Why we don't use the same date for data detect changes and incremental refresh ranges .??

 

And if Qusestion 1 answer is yes. Then let me know how to apply incremental refresh on the dimensions table. because in the dimension table I don't have any static date like order date or transaction date.

Thanks.

2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

Hi, @adeeln ;

According to your description, when setting incremental refresh, the parameter value can only be set to a static date. If you want to make the data dynamic, you may be able to change the parameter date after publishing to the service.

vyalanwumsft_0-1624609875643.png

Or use REST APT to update parameter .
In addition, incremental refresh can only be used if there is a date, if your table does not have a date column, you can consider full refresh.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

@v-yalanwu-msft Thanks for your reply.
1 . Can you please explain why it is necessary to apply Incremental refresh on a static date?. What will be their Drawbacks if we are not using static date for Incremental refresh >
2 . And what about Data Detect changes I have applied Incremental Refresh on the report like the below-attached image. Does Incremental refresh works on it or not?? 

adeeln_0-1624940313615.png

 

Thanks and Regards.
Adeel

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.