Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have some questions regarding incremental refresh.
Solved! Go to Solution.
Hi @Anonymous ,
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
When you enable and configure increment refresh in power bi desktop, you should set up parameters so you should have a date column first.
For incremental refresh, datasets are filtered by using Power Query date/time parameters with the reserved, case-sensitive names RangeStart and RangeEnd. These parameters are used to filter the data imported into Power BI Desktop, and also to dynamically partition the data into ranges once published to the Power BI service. The parameter values are substituted by the service to filter for each partition. There's no need to set them in dataset settings in the service. Once published, the parameter values are overridden automatically by the Power BI service.
Please refer the following Microsoft document, blog and case that could also help you:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply. I have some more questions.
1. If I have only one date column, such as OrderDate, and I applied the "RangeStart" and "RangeEnd" parameters on this column, can I use OrderDate to configure "detect data changes" or is there any other option? for example, duplicate OrderDate and use it to configure to detect data changes
2. If I configure the incremental update to Update rows where column OrderDate is in the last 30 days, does it mean if something has changed in the data source 40 days ago, will it not be included in the updates?
Thanks in advance!
Hi @Anonymous ,
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |