The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
A | B | C |
Table2
table2key | table2fact | table2fkey |
J | K | A |
Table3
table3key | table3fact |
Y | Z |
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.
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.