CODEWITHSUNDEEP
pysparkpowerbidaxmicrosoft-fabricspark-notebook
Joyel
Joyel

Reputation: 13

DAX query to retrieve all the tables in a dataset

I'm a Power BI admin who is loading our Fabrics Capacity Metrics data into Onelake to build a capacity metrics report with longer time frame(currently its 14 days). I'm using Fabric notebook to query the capacity metric dataset to load it. I'm referencing the MS report. While i try to load all the tables some of them are not visible by the notebook but it is available in the MS report.

Below is how i query the dataset.

df_items = fabric.evaluate_dax(
workspace="Microsoft Fabric Capacity Metrics",
dataset="Fabric Capacity Metrics",
dax_string="EVALUATE SystemEvents"  # Example for displaying one table
)
display(df_items)

i'm using the fabric library and a dax_string to go through each tables. As im not viewing all the tables in MS Capacity Metrics. Is there a way to show all the tables in the dataset?

Or, these are the tables which i'm not able to query. SystemEvents TimePoint2BackgroundDetail TimePoint2CUDetail TimePoint2InteractiveDetail TimePoint2OveragesByWorkloads TimePointBackgroundDetail TimePointCUDetail TimePointInteractiveDetail TimePointOverageDetail

Is there a way to view this tables?

Upvotes: 0

Views: 79

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89386

Capacity events will be coming to Fabric Realtime Intelligence as part of Workspace Monitoring.

Directly querying the existing capacity metrics model is fragile and unsupported.

The easiest way to get working DAX queries is probably going to be running the capacity metrics report and capturing the DAX with SQL Profiler, Log Analytics, or Workspace Monitoring.

Upvotes: 1

Related Questions