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 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
Solved! Go to 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.
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.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
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.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@Charu , there is an option to add the parameter , you should try adding new parameter and try
@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.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |