Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
How do I display the explicit table name in query advanced editor?
I am pulling 1 table for the power query from 1 folder with 180 models
In the advanced editor the explicit table name: Cover_Table001 is no longer referenced
But Cover_Table001 is explicitly referenced in the "Transform Sample File from 2020" in the function code
How do I display the Cover_Table001 table name within Query 1-Custom Function 1 within the code for the advanced editor?
Hi acohen-ih-corp,
As I know , this is default in desktop. In my test, you will see it have a query like below(it invokes a function which have corresponding table in it, so the query will know which table it refer to)
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I want to avoid the default setup for the query, only for the line containing "transform file from the folder" so that it displays the the table name "Cover_Table001".
In my example I want to display {[Item] = "Cover_Table001", Kind = "Table"]} within Query1. In your example this would be the same as displaying {[Item] = "Sheet1", Kind = "Sheet"]} inside your query titled : "the folder".
How do I make this happen?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 7 | |
| 4 | |
| 3 |