Install the latest .whl package¶

Check here to see the latest version.

In [ ]:

%pip install semantic-link-labs

Import the library and set the initial parameters¶

In [ ]:

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¶

In [ ]:

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

In [ ]:

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

Refresh specific tables¶

In [ ]:

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

Refresh specific partitions¶

In [ ]:

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

Refresh a combination of tables and partitions¶

In [ ]:

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

Clear the values of a table¶

In [ ]:

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

View semantic model refreshes¶

In [ ]:

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

Cancel a semantic model refresh¶

In [ ]:

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

In [ ]:

# 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¶

In [ ]:

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

View details of a specific semantic model refresh¶

In [ ]:

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