March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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"
}
]
}
}
Solved! Go to Solution.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
36 | |
26 | |
19 | |
11 | |
8 |
User | Count |
---|---|
54 | |
43 | |
24 | |
13 | |
12 |