Log In
Register
Home
May 17, 2019
Offline
Power Query has revolutionised my use of Excel! However, I have one spreadsheet that loads data from six different external files which are then all merged together on a daily basis. Is there any way that Excel can show the relationship between these queries (as in the visual data model of access)? If not, I guess naming the contributing queries such that it becomes obvious that they are subservient to the final query is the best solution.
See Answer
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Trevor,
There are no relationships in Power Query.
However, if you load the query results to Data Model, you will be able to create relationships between different tables like in access.
May 17, 2019
Offline
Thanks Catalin but all I wanted was a visual relationship of how 6 connections were used and merged into one query. Really just for my memory. I will sort that by using appropriate query titles then.
July 16, 2010
Offline
Hi Trevor,
Go to the View tab in the Power Query Editor > Query Dependencies. Hope that's what you want. Note: only available in 365 versions of Office as far as I know.
Mynda
Answers Post
May 17, 2019
Offline
Many thanks Mynda! Exactly what I was looking for! I've never had a good memory and at 70+ I can't say it's improving 
so this is a real help when coming back to it after a while.
1 Guest(s)
