Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?