Incremental refresh/Schedule the dataset for 2 different filters at 2 different time

[Charu]

Hi Community,

Hope you all are doing well!

Could you please help me with the below requirement is possible to achieve or not in Power BI?

And the Requirement is  "Incremental refresh typically will be partial data based on time or date range." However, in our case, we need based on the “Company code” filter.  For example, we would like company code 110 and 155 to refresh at 3 AM and Company code 165, 185, 143 to refresh at 3 PM. Is it possible to do that?

Thanks in advance

[Greg_Deckler · Accepted solution]

@Charu - So, you set refresh (incremental or not) at the data set level. Not the individual query level. So everything in the query refreshes at the same time. You could set the dataset to refresh at 3AM and 3PM and everything gets refreshed at both those times.

[pranit828 · Accepted solution]

HI @Charu 

Your ask is genuine, but unfortunatly PBI doesn't support it yet.

You can submi an Idea.

What we need to understand is when a report is created, it creates a dataset and this dataset will be refreshed as per the guidelines set by incremental refresh. This incremental refresh cannot be further broken down.

[amitchandak]

@Charu , there is an option to add the parameter , you should try adding new parameter and try

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-Period-Value-comparison-of-last-N-Mon...

[Greg_Deckler · Accepted solution]

@Charu - So, you set refresh (incremental or not) at the data set level. Not the individual query level. So everything in the query refreshes at the same time. You could set the dataset to refresh at 3AM and 3PM and everything gets refreshed at both those times.