Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have many tabs on my workbook with names like :042 , Exchange rate etc..
Is there anyway when I create a query for a tab it names the query with the tab name like 042? Or do i need to do this manaully?
Solved! Go to Solution.
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.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.