Forum Discussion
Seeing my database's structure with Power Query
Hello, I am an IT intern with some experience in databases but not a whole lot with Excel, and none with Power Query. My small company requires me to make some pivot tables with relevant info fr...
I would add a column of the column names of each table in the dB. PQ is actually THE BEST way to get an idea of what's in the database. Once you have your list of Db tables:
NewColumn = Table.AddColumn(LastStepName, "Columns", each Table.ColumnNames(_[DataTableName]))
This will list the columns in each table, right next to its table name. When I was new, I did this all the time.
--Nate