identify number of dimensions and measures in semantic model

[powerbiexpert22]

is there a way to identify number of dimensions , measures and calculated column in semantic model, i have around 20 semantic models , if i do this manually it will take lot of time

[Jihwan_Kim · Accepted solution]

Hi, 

I think you can try to utilize INFO.DAX functions in Power BI.

Or, you can also untilize those in Fabric notebook to search for all information in the capacity, if you have Fabric capacity.

Please check the below picture and the attached pbix file, and the link down below from Microsoft.

INFO functions (DAX) - DAX | Microsoft Learn

[v-sgandrathi]

Hi @powerbiexpert22,

As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
Thank you @danextian @Jihwan_Kim @Kedar_Pande for your responses to the query.

[v-sgandrathi]

Hi @powerbiexpert22,

Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.

[Kedar_Pande]

@powerbiexpert22 

Use Tabular Editor. Connect to your Power BI workspace, then run this C# script:

// Count objects across all datasets
var models = Selected.Models;
foreach(var model in models) {
Console.WriteLine(
$"{model.Name} - " +
$"Tables: {model.Tables.Count}, " +
$"Measures: {model.AllMeasures.Count()}, " +
$"Columns: {model.AllColumns.Count()}"
);
}

[ajaybabuinturi]

Thanks @danextian  and @Jihwan_Kim providing useful information.

[danextian · Accepted solution]

Hi @powerbiexpert22 

There is an external tool called model documenter which automatically creates a pbix of a documentation of a semantic model

The tool can be installed using Business Ops external tools installer - https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Business-Ops-The-largest-collectio...

[Jihwan_Kim · Accepted solution]

Hi, 

I think you can try to utilize INFO.DAX functions in Power BI.

Or, you can also untilize those in Fabric notebook to search for all information in the capacity, if you have Fabric capacity.

Please check the below picture and the attached pbix file, and the link down below from Microsoft.

INFO functions (DAX) - DAX | Microsoft Learn