Power Query Link to Table

Occasional Visitor
 
 

Hi, 

 

I have created several tables in Power Query, and i have a seperate query table with the base tables appended together, all in the same workbook. 

 

I am trying to add a column in the appended table which would allow me to click and jump to the source table, IE a hyperlink to the base table. 

 

Not sure on the best approach to this, whether some kind of drill down or just a hyperlink to the table?

 
 
1 Reply
You might try manually adding an additional column with a formula such as this one:
=HYPERLINK("#"&[@[TableName]],"Link to "&[@[TableName]])
this formula assumes there is a column in your query named "TableName" which contains the name of the tables.