Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
eyJrIjoiYmM1Y2IyYTItYjk4Mi00NDgyLTgzOWYtYjAzODAwMTdjYWU4IiwidCI6ImEwZTZmOTIyLThhZWQtNDdhYi1hOWZlLWI4YzYwZWIyYThjYSJ9
are you able to share the file?
Hello,
Could you share the pbix please?
Thank you
Kiran.
Is this directly related to a tabular model? Meaning you could change the connection string to a differnt cube and the file would automatically work?
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.
Thanks
Bhavesh
Would you mind giving a little more detail on what is meant by "point the connection to the different cube"? Also, which AdventureWorks db version is being used in the analysis?
I like the overall approach to the analysis.
Hello,
Could you share the pbix please?
Thank you
Ramakrishna
@BhaveshPatel wrote:
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.
Thanks
Bhavesh
.
Could you share the pbix?
Would like to study how you made some of the visuals.
Thank you!
If you're looking for the inspiration for creating your own version, which includes a downloadable Power BI Template, I'd suggest a visit to https://datasavvy.me/2017/09/19/the-tabular-model-documenter-is-now-a-power-bi-template/