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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jmdatasci
Frequent Visitor

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, @jmdatasci #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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.