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.


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

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

  4. We have been using your Documentation files successfully since your first blog post. However, recently (past month or two), the file does not refresh. There is an error at the Perspective Items query… “Query ‘Perspective Items’ (step ‘Expanded NewColumn2) refrences other queires or steps, so it may not directly access a data source. Please rebuild this data combination.”

    Any ideas on how to fix this as we love the Power BI tabular documentation solution?!

    1. Someone else contacted me about that as well. We tried opening the Power BI model and refreshing the queries individually in the Query Editor and everything worked fine from there. If you don’t have perspectives (because you are using this on another Power BI model) you can delete any queries related to perspectives. I’m currently working on an updated version, but I have a lot going on so it might not be ready for a couple of months.

      1. Thanks for the quick reply. Telling our clients to have to refresh each query seemed a little clunky so I went hunting for another fix. It seems to be a query folding issue regarding the Privacy level of the data source you are documenting. So if you go to Data Source settings and Edit Permissions and then change from None to be either Organizational or Private, the query.firewall error is not thrown upon refresh.

        I think that there is a better way to fix this by adjusting the underlying query structure but I needed a quick win. There are some articles posted about this error that I think may help us but I am not as savy with M/SQL as you are I am sure. See

  5. OK…I was able to fix the firewall error. Under File – Options, there are two Privacy tabs, the first is global and you will want to make sure the center radio button is selected that says Combine data according to each file’s Privacy Level settings. Next, click on the Current FIle – Privacy tab in the same options menu and select the Ignore the Privacy Levels and potentially improve performance option. This will allow you to refresh your report without error or having to bother with every query in the Edit queries view.

Leave a Reply

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

You are commenting using your 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