Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 refres...
Need Help
Tips and Tricks
  • nilendraFabric's avatar
    nilendraFabric
    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-link

     

    Use `fabric.list_partitions()` to verify refresh timestamps

    If this is helpful please give kudos and accept the answer