Forum Discussion
Refresh Partitions
- 1 year ago
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
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-link
Use `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