Forum Discussion
Using Power Query to Map my Excel Query Database
This might be the wrong place for this but i was wondering if anyone has used Power Query to map their Database connections? the end goal is to create a Sankey visual in power bi which essentially sh...
I have a similar request; to document my Power Query dependencies I have to take snapshots of the trees and paste them together. Documenting the flow is really key to describing the process. Being able to filter out things like Transform and Sample files would help, too.
It's frustrating since the logic of reporting it is already there.
Another workaround I have is copying my entire data model (less the transformations for expanding files) and thenm manually stitching together all the dependencies referring to other queries as Sources or in Merged Queries.
Thanks,
David