cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnthonyTilley Established Member
Established Member

Table List and Field List

Does anyone know a way to export a list of each table and its fields along with meta data such as data type etc from the power BI model.

 

I have a large data model with some 40 tables and hundreds of fields including a lot of calcualted colunms and measures. i would like to eport a list of all of the fields so that i can begin working a data dictionary. im looking for the best way to extract this infomration

 

alternativly is there any tool that i can connect directly to the data model in power bi and build a data dictionary.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
HotChilli New Contributor
New Contributor

Re: Table List and Field List

DAX Studio.  You can use the DMV's like

 $SYSTEM.DBSCHEMA_COLUMNS

to get this type of info.

 

You can use SQL Server also (you can get the server name from DAX studio - to connect)

View solution in original post

1 REPLY 1
Highlighted
HotChilli New Contributor
New Contributor

Re: Table List and Field List

DAX Studio.  You can use the DMV's like

 $SYSTEM.DBSCHEMA_COLUMNS

to get this type of info.

 

You can use SQL Server also (you can get the server name from DAX studio - to connect)

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,570)