sempy_fabric_powerbi_semantic_model_dax_query_quickstart.py

1import sempy.fabric as fabric
2
3# List all workspaces the user has access to
4workspaces = fabric.list_workspaces()
5display(workspaces)
6
7# List all semantic models (datasets) in a specific workspace
8# Replace "Your Workspace Name" with your actual workspace name
9datasets = fabric.list_datasets(workspace="Your Workspace Name")
10display(datasets)
11
12# List all tables within a specific semantic model
13# Replace "Your Dataset Name" with your actual dataset name
14tables = fabric.list_tables(dataset="Your Dataset Name", workspace="Your Workspace Name")
15display(tables)
16
17# Execute a DAX query against the semantic model and return the result as a pandas-compatible Fabric DataFrame
18dax_query = """
19EVALUATE
20    SUMMARIZECOLUMNS(
21        'Table'[Column1],
22        "Total Value", SUM('Table'[Column2])
23    )
24"""
25
26df = fabric.evaluate_dax(
27    dataset="Your Dataset Name",
28    workspace="Your Workspace Name",
29    dax_string=dax_query
30)
31
32# Display the resulting data
33display(df.head())