Forum Discussion
How do I use the tab name as my query name
Hi craig811
Yes, access the file like described here (https://www.poweredsolutions.co/2018/06/11/navigation-window-folder-in-power-query-and-power-bi/ ), so that you have a table containing all the elements from your xlsx ("Edit" is called "Transform data" now).
Then right-click your mouse in column "Data" and choose "
Query names will be suffixes with "_sheet", but thats quicker to delete than to type in all the sheet names manually.
Hi craig811
Yes, access the file like described here (https://www.poweredsolutions.co/2018/06/11/navigation-window-folder-in-power-query-and-power-bi/ ), so that you have a table containing all the elements from your xlsx ("Edit" is called "Transform data" now).
Then right-click your mouse in column "Data" and choose "
Query names will be suffixes with "_sheet", but thats quicker to delete than to type in all the sheet names manually.
- Nice ImkeF , never knew you could do that!
