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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Don-Bot
Helper II
Helper II

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors