Since DMVs require DMX queries, you are somewhat limited in your ability to join the data from the DMVs together. For more information analyzing your Power BI model, see Chris Webb’s post. You’ll just need to change the connection information to your Power BI instnce while the.
I’ve been able to figure out the descriptions that correspond to some of the values, but I’m still missing a few.Īs with the MDSCHEMA DMVs, the TMSCHEMA DMVs can be used to document your model. There are a few fields that show IDs rather than descriptions (e.g., ExplicitDataType in TMSCHEMA_COLUMNS, Type in TMSCHEMA_DATA_SOURCES). While there are 36 TMSCHEMA DMVs, the main DMVs you will want to check out for model documentation purposes are: Until then I published a Gist that provides a list of those views as well as some notes on what kind of useful info is in each one. I expect them to show up here at some point in the future. They are, unfortunately, not documented at this time (as of ). Not to worry, though. With the new compatibility level 1200 SSAS Tabular models came some new DMVs. For example, the MDSCHEMA_MEASUREGROUP_DIMENSIONS DMV seems to just return one row per table rather than a list of the relationships between tables. If you were used to documenting your SSAS model using the MDSchema rowsets, you might have noticed that some of them do not work with the new tabular models.
0 kommentar(er)
