Everybody has already encountered the fact to create a documentation about a dataset used in Power BI or about an Analysis Services tabular cube. What a painful task to do it manually ! There are a bunch of tools that can be used to do automate it. I will present you the one that can extract those informations into an excel file !
That magic tool is named : “BISM SSAS Tabular Documentation Tool”
This is a free and open-source tool made by Sorna kumar Muthuraj.
This tool generate a documentation for a Power BI model or for a tabular cube.
The documentation generated contains informations about :
- Server and informations about connections
- Dimensions and their sources (query)
- DimensionAttributes
- Relationships
- Hierarchies
- Measures
- KPIs
- Partitions
- Perspectives
- Roles
The excel document created contains a tab for each of those element.
Here is a screenshot of the application and the informations that you have to fill
SSAS:
![BISM SSAS Documentation Tool](https://i0.wp.com/easybi.be/wp-content/uploads/2021/12/image-1.png?resize=740%2C616&ssl=1)
Power BI:
![](https://i0.wp.com/easybi.be/wp-content/uploads/2021/12/image-2.png?resize=740%2C616&ssl=1)
Here is a preview of the informations that the document can contain:
![](https://i0.wp.com/easybi.be/wp-content/uploads/2021/12/image-5-1024x104.png?resize=740%2C75&ssl=1)
![](https://i0.wp.com/easybi.be/wp-content/uploads/2021/12/image-3.png?resize=740%2C86&ssl=1)
![](https://i0.wp.com/easybi.be/wp-content/uploads/2021/12/image-4.png?resize=740%2C73&ssl=1)
How to download:
This tool can be obtained via github:
https://github.com/msornakumar/BISM-SSAS-Tabular-Documentation-Tool
You can go to the EXE folder and download the version that you want (portable or installer). I suggest you to download the .MSI version, like that all the dependencies will be installed too.
![](https://i0.wp.com/easybi.be/wp-content/uploads/2021/12/image-6.png?resize=740%2C184&ssl=1)
![](https://i0.wp.com/easybi.be/wp-content/uploads/2021/12/image-7.png?resize=544%2C220&ssl=1)
I hope this tool will help you as much that it helped me !