06-30-2018 20:51 PM - last edited 07-02-2018 22:26 PM
This Power BI Dashboard is showing the structure of AdventureWorks Analysis Services Tabular Models. It can also be used to document tabular models created in Power BI, SSAS or Excel Power Pivot. Furthermore, the dashboard provides in depth analysis of where Analysis Services model optimization is required.
The model includes:
---> Tables & its relationships & associated meta data
---> Columns & its relationships & associated meta data
---> Relationships, its cardinality & associated keys
---> Measures, its dependencies & DAX Code
---> Security & its management
---> Power Query definitions & its M Code
---> Calculated Columns & its DAX Code
---> Calculated Tables & its DAX Code
---> User Hierarchies
---> Encoding, Compression & its meta data
---> Data Types etc.
See the subsequent pages in this report for detailed information.
Yes it does.
You can point the connection parameters to the different cube and it will refresh with the metadata of the model.
You can use it to document Power BI, SSAS Tabular and Power Pivot Data Models.