semantic_link_labs_powerbi_list_datasets_and_dax_query.py

1import sempy_labs as labs
2from sempy_labs import query
3
4# Set your workspace and dataset name
5workspace_name = "Your Workspace Name"
6dataset_name = "Your Dataset Name"
7
8# List all datasets in the specified workspace
9datasets = labs.list_datasets(workspace=workspace_name)
10print("Datasets in workspace:")
11print(datasets)
12
13# Execute a simple DAX query against a specific dataset
14# This example calculates the total row count of a table named 'Sales'
15dax_query = "EVALUATE ROW('Total Rows', COUNTROWS('Sales'))"
16results = query.run_dax(dataset=dataset_name, workspace=workspace_name, dax_query=dax_query)
17
18# Display the results
19print("\nDAX Query Results:")
20print(results)