Refresh a Semantic Model 03-24-2025 15:17 PM - last edited 03-27-2025 13:13 PM

[mikova]

Download this notebook from: semantic-link-labs/notebooks/Semantic Model Refresh.ipynb at main · microsoft/semantic-link-labs · G...

Install the latest .whl package

Check here to see the latest version.

%pip install semantic-link-labs

Import the library and set the initial parameters

import sempy.fabric as fabric
import sempy_labs as labs
dataset = '' # Enter your dataset name
workspace = None # Enter your workspace name (if set to None it will use the workspace in which the notebook is running)

Refresh a semantic model

labs.refresh_semantic_model(dataset=dataset, workspace=workspace)

Visualize the refresh of a semantic model

The resulting dataframe returns the trace logs capturing the details of the refresh operation

df = labs.refresh_semantic_model(dataset=dataset, workspace=workspace, visualize=True)

Refresh specific tables

labs.refresh_semantic_model(dataset=dataset, workspace=workspace, tables=['Sales', 'Geography'])

Refresh specific partitions

labs.refresh_semantic_model(dataset=dataset, workspace=workspace, partitions=["'Sales'[Sales FY20]", "'Sales'[Sales FY21]"])

Refresh a combination of tables and partitions

labs.refresh_semantic_model(dataset=dataset, workspace=workspace, tables=['Geography', 'Calendar'], partitions=["'Sales'[Sales FY20]", "'Sales'[Sales FY21]"])

Clear the values of a table

labs.refresh_semantic_model(dataset=dataset, workspace=workspace, refresh_type='clearValues')

View semantic model refreshes

fabric.list_refresh_requests(dataset=dataset, workspace=workspace)

Cancel a semantic model refresh

labs.cancel_dataset_refresh(dataset=dataset, workspace=workspace)

# Specify the request_id based on a value from list_refresh_requests
labs.cancel_dataset_refresh(dataset=dataset, workspace=workspace, request_id='')

View a semantic model's refresh history

labs.get_semantic_model_refresh_history(dataset=dataset, workspace=workspace)

View details of a specific semantic model refresh

labs.get_semantic_model_refresh_history(dataset=dataset, workspace=workspace, request_id='')

https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fsemantic-link-labs%2Fblob%2Fmain%2Fnotebooks%2FSemantic%2520Model%2520Refresh.ipynb