CODEWITHSUNDEEP
sql-serverpowerbissasdaxssas-tabular
astroluv
astroluv

Reputation: 793

How to create a DAX measure that extracts Information from the metadata of Tabular model in SSAS or Power BI.?

I have just started learning the SQL Server and Power BI. I'm working on a project and for that i need to create a Measure for the Power BI report that will dynamically extracts the information about all the tables (like Table Name, Last Updated, Dependencies, etc) used in the Tabular solution.

I couldn't find any satisfactory answer anywhere. Is there anyone here who could help?

Upvotes: 0

Views: 1193

Answers (2)

StelioK
StelioK

Reputation: 1781

If you are using an SSAS tabular data model or multi-dimensional cube, you can use DMVs to extract meta data to report on or analyze.

This ARTICLE includes a great walk through and a power bi template you can use to report on metadata.

Hope it helps!!

Upvotes: 1

Alexis Olson
Alexis Olson

Reputation: 40224

DAX isn't going to do this for you. However, there are 3rd party tools like Power BI Helper that will allow you to extract model details.

Upvotes: 1

Related Questions