Microsoft Technologies, Power BI, SSAS

The Tabular Model Documenter is now a Power BI Template

A while back I created the Tabular Model Documenter Power BI model that can connect to your SSAS Tabular or Power BI model and display metadata about the model to help you see relationships, calculations, source queries, and more.  I had been meaning to turn it into a parameterized template since templates became available and just finally got around to it.

You can now download the PBIT file here. Note: This works for SSAS 2016/compatibility level 1200, but may need some adjustments for Azure AS and SSAS 2017.

When you open it, you’ll need to fill in the instance and database name, then allow some native queries to run. Then you will have your tabular model documented for you without a lot of manual effort.

tabular-doc-relationships

For more info on how to use the Tabular Model Documenter, see the original post.

14 thoughts on “The Tabular Model Documenter is now a Power BI Template”

    1. This works for 1200 compatibility level models (SQL Server 2016). The DMVs changed at that point when we switched to the JSON (TMSL) back end. I haven’t tested with 1400, but I think it should still work. Let me know if you find otherwise.

  1. I’m finding that it doesn’t work for either – there are a bunch of columns in DBSCHEMA_CATALOGS for 1600 that don’t exist in 1400. Do you mind if I just fix it up myself?

    Thanks, really looking forward to using it.

  2. I am trying to use the template but am getting the query.firewall error from your previous post on this. I do not have any perspectives so am thinking that might be causing an issue. What would you suggest. 2016 tabular model.

  3. I am having trouble building the model and am coming across the query.firewall issue you outlined in your previous post. Is there a workaround to this?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s