Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • foodd's avatar
    foodd
    3 years ago

    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.