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.
Hello!
I am currently working to create a report which a huge amount of data and using the Incremental Refresh functionality to get the data.
With that, I have few question and hopefully get an answer here.
1) When I develop the report, I set the RangeStart and RangeEnd. E.g. when I set todays date for the RangeEnd, but then publish the report in 2 weeks, does it automatically use the "current date" as RangeEnd or do I have always to update the RangeEnd before I publish it?
2) What happens when I delete a data in the backend? Do I need to do a full refresh?
Many thanks for your help.
Joerg
Solved! Go to Solution.
Hi @JoergSch
Thanks for reaching out to us.
you don't need to update the RangeEnd before you publish it. RangeStart and RangeEnd, defined in the Manage Parameters dialog in Power Query Editor are initially used to filter the data loaded into the Power BI Desktop model table to include only those rows with a date/time within that period. After the model is published to the service, RangeStart and RangeEnd are overridden automatically by the service to query data defined by the refresh period specified in the incremental refresh policy settings.
For more, please read this article https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
And its
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @JoergSch
Thanks for reaching out to us.
you don't need to update the RangeEnd before you publish it. RangeStart and RangeEnd, defined in the Manage Parameters dialog in Power Query Editor are initially used to filter the data loaded into the Power BI Desktop model table to include only those rows with a date/time within that period. After the model is published to the service, RangeStart and RangeEnd are overridden automatically by the service to query data defined by the refresh period specified in the incremental refresh policy settings.
For more, please read this article https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
And its
Best Regards,
Community Support Team _Tang
If this post helps, 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.