Forum Discussion
Refresh Partitions
Hello everyone!
I’m working with a semantic model on Microsoft Fabric where I use incremental refresh to update data for the last two months while archiving data for previous years. With each refresh, only the data for the most recent two months is updated.
However, in certain situations, I may need to refresh specific partitions, such as an order partition, outside of the regular incremental refresh schedule.
Is there a way to selectively refresh specific partitions, like the order partition, without affecting the rest of the model?
Thanks in advance for your help!
Hello Anonymous
you can selectively refresh specific partitions in Microsoft Fabric semantic models with incremental refresh using Python via Semantic Link
import sempy.fabric as fabric
# Define target tables/partitions
objects_to_refresh = [
{"table": "Customers", "partition": "Customers-ROW"},
{"table": "Order_Details"} # Refreshes entire table
]# Execute partial refresh
fabric.refresh_dataset(
workspace="Sales",
dataset="SL-Refresh",
objects=objects_to_refresh
)Supports multiple refresh types (`DataOnly`, `Full`, `Calculate`)
https://fabric.guru/refreshing-individual-tables-and-partitions-with-semantic-linkUse `fabric.list_partitions()` to verify refresh timestamps
If this is helpful please give kudos and accept the answer
4 Replies
Hello Anonymous
you can selectively refresh specific partitions in Microsoft Fabric semantic models with incremental refresh using Python via Semantic Link
import sempy.fabric as fabric
# Define target tables/partitions
objects_to_refresh = [
{"table": "Customers", "partition": "Customers-ROW"},
{"table": "Order_Details"} # Refreshes entire table
]# Execute partial refresh
fabric.refresh_dataset(
workspace="Sales",
dataset="SL-Refresh",
objects=objects_to_refresh
)Supports multiple refresh types (`DataOnly`, `Full`, `Calculate`)
https://fabric.guru/refreshing-individual-tables-and-partitions-with-semantic-linkUse `fabric.list_partitions()` to verify refresh timestamps
If this is helpful please give kudos and accept the answer
You can refresh the partitions by connecting to semantic model via SSMS using XMLA endpoint.
Reference Link: https://www.youtube.com/watch?v=OYYnoMa-93g
You can refresh it by connecting to semantic model via SSMS using XMLA endpoint.
Reference Video: Can you refresh a single table in Power BI?
Hi Anonymous,
Thanks nilendraFabric for Addressing the issue.
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Regards,
Vinay Pabbu
