Skip to main content

Power BI

New

View model metadata (tables, relationships, columns, measures) for all models across a tenant

Vote (58) Share
Meagan's profile image

Meagan on 10 Nov 2016 03:42:42

I would like to be able to query the tables, columns, DAX calculations (columns and measures), and data source queries for datasets published to PowerBI.com. This would allow me to determine if I have many similar models that could be combined, or if I have multiple models defining the "same metric" differently. Having this information would help manage usage of space in Power BI and provide information for organizations to see where they are perhaps in need of master data management (or simply conversations about data definitions). If we could combine this metadata with usage information (which datasets are used, what columns are used), that could be powerful from an administrative perspective.

Comments (3)
Meagan's profile image Profile Picture

021e0ce0 29ed-48f6-9846-c1a03553b0f1 on 05 Jul 2020 23:34:45

RE: View model metadata (tables, relationships, columns, measures) for all models across a tenant

when can we get the power BI API using which we can get the table's field values?
it'll be more appreciable if this feature will come soon.

Meagan's profile image Profile Picture

c303b574 10e0-419d-8e54-21fcec88bd7f on 05 Jul 2020 23:31:26

RE: View model metadata (tables, relationships, columns, measures) for all models across a tenant

I want to modfiy the columns allowing to add, delete , rename them. Or at least there should be a way to delete the whole table i.e metadata and data. So that one can create a new table.

Meagan's profile image Profile Picture

3e2a003f 09fc-409c-b900-60b7846ae9c7 on 05 Jul 2020 22:52:59

RE: View model metadata (tables, relationships, columns, measures) for all models across a tenant

I need this information too. My application is pushing data to a dataset. If I would add a new column in the dataset of PowerBI, I could get the information about the unbinded column in my application.