Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.