Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Exporting list of all tables and features

Hi all, I have been searching for a while and can't seem to figure out a way to do this but what I am trying to do is export a list of all of the table connections and features/column so for instance I would have data source tables table1, table2, table3 and then features that vary for each for instance:

Table1 

table1key   table1fact   table1fact2   
ABC

 

Table2

table2key   table2fact   table2fkey
JKA

 

Table3

table3key   table3fact
YZ

 

Right now I have inherited a report that has the sidebar with the table names (manual loaded for most) and then the columns/value names that are used in the report so I don't have any data dictionary or something to start with. 

 

So I would love to somehow get an export in a list saying

 

table1 - table1key

table1 - table1fact

table1 - table1fact2

table2 - table2key

table2 - table2fact

table2 - table2fkey

table3 - table3key

table3 - table3fact

 

but the main challenge comes that I can't copy paste the text in the sidebar or anything and there are too many tables/values to manually input or screenshot/OCR.

 

Any advice would be greatly appreciated.

1 REPLY 1
AlienSx
Super User
Super User

Hi, @Anonymous #sections[Section1] gives you a list of record of all your queries. Start with this. Unless you really meant sources for your queries. Then #sections won't work. 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.