Forum Discussion
How to use Power bi desktop model view Properties fields to build list of Definitions for App users
Hi, I would like to use "Description" field from "Properties" in Model view power bi dektop to build "List of Report Definitions" for report users, that consume report via Power Bi App: Is...
Anonymous, you can use DAX Studio to retrieve this via Dynamic Management View (DMV). I don't have the script handy, though, if you begin with these three DMVs as starting points:
- Retrieve GUID from Power BI Model: SELECT [CATALOG_NAME] FROM $SYSTEM.DBSCHEMA_CATALOGS
- Retrieve Table ID: select * from $SYSTEM.TMSCHEMA_TABLES
- Retrieve Table and Column Info: Select * from $SYSTEM.TMSCHEMA_COLUMNS as a starting point
This can be extended to measures, etc.
foodd
Community Champion
Community ChampionAnonymous, you can use DAX Studio to retrieve this via Dynamic Management View (DMV). I don't have the script handy, though, if you begin with these three DMVs as starting points:
- Retrieve GUID from Power BI Model: SELECT [CATALOG_NAME] FROM $SYSTEM.DBSCHEMA_CATALOGS
- Retrieve Table ID: select * from $SYSTEM.TMSCHEMA_TABLES
- Retrieve Table and Column Info: Select * from $SYSTEM.TMSCHEMA_COLUMNS as a starting point
This can be extended to measures, etc.