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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Don-Bot
Resolver I
Resolver I

Force a refresh on a specific incremental partition

How do I force power bi to refresh an incremental partition.  Regardless of whether the update date time or the creation date matches the incremental policy setup when implemented.  I only want to clear and update one partition at a time.

How can I force a refresh?  

I've tried the below xmla but it only appears to refresh if the criteria matches...

 

 

{
  "refresh": {
    "type": "automatic",
    "objects": [
      {
        "database": "SALES DATA",
        "table": "SALES",
        "partition": "2023Q41219"
      }
    ]
  }
}

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

change the type to full.

 

Refresh command (TMSL) | Microsoft Learn

 

Note that if you have dependencies (like auto date/time) then the related partitions will be refreshed as well.

 

 

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

change the type to full.

 

Refresh command (TMSL) | Microsoft Learn

 

Note that if you have dependencies (like auto date/time) then the related partitions will be refreshed as well.

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.