Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
Would anyone know how to retrieve in power query language M the name of the spreadsheet hosting a given table? For exemple, let us assume i have a table named "Sales_Per_Region" on "tab1" spreadsheet, how can I ask power query to return "tab1" as the OUTPUT with "Sales_Per_Region" as an INPUT?
Thank you
Antoine
Solved! Go to Solution.
Power Query by itself can't do it unfortunately.
But there are some work-around you may find useable:
I found chat-gpt very helpful in writing the functions specific to my situation.
I ended up not using any of these methods because of all the downsides, so I can't share my solution with you...
Power Query by itself can't do it unfortunately.
But there are some work-around you may find useable:
I found chat-gpt very helpful in writing the functions specific to my situation.
I ended up not using any of these methods because of all the downsides, so I can't share my solution with you...
Thank you very much for your detailed answer and multiple suggestions of solution!
You're welcome. What solution did you go for?