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 am connecting Mindbody API as the Web API data source, and am researching whether there is any possibility to apply the incremental refresh on those connectivities.
I've done the below steps when attempting on setting the incremental refresh:
Below is the before-after of clicking the refresh bottom.
I was assuming after the refresh, the earliest date/time should stay the same whereas the lastest date/ time will get extended.
Can anyone please advise the reason that my incremental refresh is not working functionally?
Before
After
Thank you in advance.
Solved! Go to Solution.
Hi @Anonymous
Did you refresh it in Power BI Desktop? Incremental refresh only works in Power BI Service. When in Power BI Desktop, the date range is decided by the given values of RangeStart and RangeEnd parameters.
If you want to see how incremental refresh works, you need to publish the report to Power BI Service, then refresh the dataset in Power BI Service. The incremental refresh policy will be applied in each subsequent refresh after the first full refresh happened in Power BI Service. RangeStart and RangeEnd parameters will be updated automatically in Power BI Service according to the policy.
Please refer to Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hello,
I am currently working to connect Mindbody API with Power BI, can you please guide me through the process.
Thanks,
Hi @Anonymous
Did you refresh it in Power BI Desktop? Incremental refresh only works in Power BI Service. When in Power BI Desktop, the date range is decided by the given values of RangeStart and RangeEnd parameters.
If you want to see how incremental refresh works, you need to publish the report to Power BI Service, then refresh the dataset in Power BI Service. The incremental refresh policy will be applied in each subsequent refresh after the first full refresh happened in Power BI Service. RangeStart and RangeEnd parameters will be updated automatically in Power BI Service according to the policy.
Please refer to Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@Anonymous , it will keep rolling 1 month of data
Hi @amitchandak , can you please describe further?
I thought this setting will archiving the past 1 month, and incrementally refresh the past 2 days of data. Thanks.
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 |
---|---|
107 | |
97 | |
75 | |
63 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |