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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
Centurius_de
Frequent Visitor

Incremental Update with Druid Query

Dear all, 

i have setup a druid query in powerbi to pull some busiess data into power bi. 

The query contains an interval parameter to define the date range to be collected. 

 

 

   ""intervals"": ""2023-01-01T00Z/2023-03-01T00Z"",

 

 

I have already setup a RangeStart and RangeEnd Parameter. 
The dates are stored in a "date" column of type date/time.

is there anything else I need to do with the query to activate incremental updates? 

Centurius_de_0-1676988130115.png

 


I am not sure if Powerbi is able to automatically apply now the parameters or if I need to do anything else in addition with the query


1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@Centurius_de You at least need to setup the Incremental refresh policy in the Service. See this: Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

@Centurius_de You at least need to setup the Incremental refresh policy in the Service. See this: Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.