Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
9 | |
7 | |
6 | |
6 |