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
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
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
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 6 members 2,409 guests
Please welcome our newest community members: