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,
Can anyone help me with the below questions .
I want to find a way to set up the below data model to custom refresh based on the Entity parameter. That is to refresh one Entity rather than refreshing all when I click refresh data.
Any help is greatly appreciated.
Thanks,
Deevs
Hi, @deevs
It’s my pleasure to answer for you.
1.The data source for incremental refresh need to support query folding.
You can check and understand it here.https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh
https://sqldusty.com/2020/05/20/power-bi-incremental-refresh-with-web-api-data-source/
If your data type isn't datetime, you can convert it in the following form.
(x as datetime) => Date.Year(x)*10000 + Date.Month(x)*100 + Date.Day(x)
2.You can set the data you want to refresh through the following settings when you click the refresh button in visual pane or PQ.
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Let's say your API only supports date values. In order to make RangeStart and RangeEnd work with that you can add a random time value to your date, for example midnight UTC
So 2020-11-09 becomes 2020-11-09T00:00:00.000Z
etc.
1. Incremental refresh needs to filter your data source with the RangeStart and RangeEnd parameters (technically datetime fields, but you can work around that with casting). Does your API source support that?
2. Please be more specific, it is not clear to me what you are trying to achieve. Are you expecting this to work in the Power BI service?
Hi @lbendlin
1. I didn't quite understand the casting. Can you elaborate on that please? How do I figure whether the API supports casting?
2. I am trying to do that on power BI desktop.
Thanks,
Deevs
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.