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 

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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