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?
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!!