Forum Discussion

AnthonyTilley's avatar
AnthonyTilley
Solution Sage
7 years ago
Solved

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

    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)

mTalha_Khan's avatar
mTalha_Khan
New Member
3 years ago

you also make inforamation Schema table by using "Table.Schema(TableName)".

steps for multiple tables:

// Create a blank query in power Query editor
// open the Advance editor and paste the script.
// update the tables name and save.

let
Source = Table.Schema(fristTable),
CustomColumn_Table1 = Table.AddColumn(Source, "QueryName", each "fristTable"),
secondTable_schema=Table.Schema(secondTable),
customColumn_Table2 = Table.AddColumn(secondTable_schema, "QueryName", each "secondTable"),
Final_Table = Table.Combine({CustomColumn_Table1 ,customColumn_Table2 })
in
Final_Table

 

Note: For 2 or more tables repeat the steps under the "let" and put final output variable after "in" label.