sempy_fabric_powerbi_dataset_to_dataframe_quickstart.py

1import sempy.fabric as fabric
2
3# List all workspaces available to the user
4workspaces = fabric.list_workspaces()
5print(workspaces)
6
7# List all datasets (semantic models) in a specific workspace
8# Replace "Your Workspace Name" with your actual workspace name
9datasets = fabric.list_datasets(workspace="Your Workspace Name")
10print(datasets)
11
12# Load a table from a specific Power BI dataset into a Fabric DataFrame
13# Replace "Your Dataset Name" and "Your Table Name" with your actual names
14df = fabric.read_table("Your Dataset Name", "Your Table Name", workspace="Your Workspace Name")
15
16# Display the first few rows of the DataFrame
17print(df.head())