Be among the first 100 to jump on board "The Query Editor" newsletter 🚀. It's packed with super-actionable tips and insights. Why should you be excited? 🌟 Because the first 100 subscribers will receive an exclusive 50% discount on my upcoming mini-course, set to drop early next year (or perhaps even sooner)! 🤞Just hit this link to subscribe thequeryeditor.beehiiv.com/subscribe 🚀🔥
I took 6 hours looking for this solution on web. Thank you very much for this clear and helpful video! The change on File/Option/ Privacy... amazing. Now I can continue my work!
Its pretty complex, but following this tutorial and setting up Power Query can save you tons of time and bring efficiency into your reporting. I do Agree.
This video is amazing! You have taught me how to use Excel in ways that I never imagined. You have helped me to improve my skills and productivity. Thank you!!!
Hi T Lee, you're most welcome :). If the gear icon is not available at Source in your Query Settings, you have the option of editing the code in the Advanced Editor, click Home -> Advanced Editor or you can click on View -> Advanced Editor. Let me know if it works?
Thank you Bhaskar and yes you could definitely create a dropdown for file path. Here is the link to the video for rebuilding the data combination: ua-cam.com/video/SLn5sAL3WnQ/v-deo.html
Hi thank you for this video and I have created File path, but renaming to original table 'ExcelFilePath' Object is missing after File.Contents. please let me know if we have the solutions for this.
Hi Ian, it's a pleasure. You can most certainly create a dynamic file path in an Excel cell where the file is in a SharePoint folder. I will release a video on this for you, please hit the notification bell so you're notified for when the video is released.
I set my power query to get data from folder (YYYY) this folder has excel sheets named Q.P MM, and it filters out any excel sheet doesnot start with Q.P. My question is can I apply this so i can change the source folder YYYY for different years as long as criteria Q.P MM still apply in all folders?
If I have more than workbook in one folder and each workbook has a different names and I need to take one of those workbook to be as sample for rest of them and the upcoming workbook also what can I do
Hello @missmicrosoft I am suffering an issue. I am connecting a cell path in excel to power query but once I change the path of trhre file irt do not work. can you help?r
File names need to be the same? Oh no. I have a few hundred TXT files. I need to import one by one to Excel. My query already separates the TXT files by topics (headers) and transforms those into MARKDOWN text, so I use PowerAutomate Desktop to copy parts of the text and paste each part in an appropriate FIELD of a document system. The problem lies exactly in automating the change of source txt files used by PowerQuery. I have a list of the txt files. All in the same path. I can make PowerAutomate change the filepath and filename (based on that list) in a cell, and need PowerQuery to change the query source based on that.
Be among the first 100 to jump on board "The Query Editor" newsletter 🚀. It's packed with super-actionable tips and insights. Why should you be excited? 🌟 Because the first 100 subscribers will receive an exclusive 50% discount on my upcoming mini-course, set to drop early next year (or perhaps even sooner)! 🤞Just hit this link to subscribe thequeryeditor.beehiiv.com/subscribe
🚀🔥
I took 6 hours looking for this solution on web. Thank you very much for this clear and helpful video!
The change on File/Option/ Privacy... amazing.
Now I can continue my work!
You’re most welcome 😊, I’m glad the video was helpful!
Hi it would be really helpful to learn how to rebuild data combination to prevent security issues when ignoring error
Hi, please check out this video here on how to rebuild the data combination: ua-cam.com/video/SLn5sAL3WnQ/v-deo.htmlsi=iFrKgFf9uFEGarFI
Its pretty complex, but following this tutorial and setting up Power Query can save you tons of time and bring efficiency into your reporting. I do Agree.
Thank you Vinod for your support always 😊 Power Query is pretty awesome :D
This video is amazing! You have taught me how to use Excel in ways that I never imagined. You have helped me to improve my skills and productivity. Thank you!!!
You are so welcome! I'm glad the video was helpful 😊
You are imaging ....... Thank you so much for sharing this & saving times of US ..keep Posting... 🙏🙏
Thank you Dhun, I'm so glad you find the video helpful! And I will keep posting, your support means a lot :)
Very clear and concise. This is exactly what I am looking for. Thank you!
Thank you so much for this very clear explanation! 🙏
Wow! Nicely explained.. today only I saw your video... going forward,Will keep on following you.
Thank you so much Santosh! Appreciate the support :)
Realy good and clear explained! Helped me a lot! Thanks
You're most welcome and I'm so glad the video helped you eef!
Nice and clear explanation of dynamic parameters. Subscribed to your channel 😊
Thanks for the sub! :)
Wow What wonderful idea, Appreciate.
Many many thanks
Thank you so helpful
You're welcome!
Thank you!!!
Good video. Would be useful to have a video on rebuilding data combination :)
Thanks Erik! I will definitely make that video. Please hit the notification bell so that you know when it’s released :)
Hi Erik, please see the recent video that shows you how to rebuild the data combination, here is the link: ua-cam.com/video/SLn5sAL3WnQ/v-deo.html
@@MissMicrosoftThank so much for your "rebuild" clip.
Thank you for your wonderful tutorials. How do I change data source when the gear icon is not available at Source in Query Settings?
Hi T Lee, you're most welcome :). If the gear icon is not available at Source in your Query Settings, you have the option of editing the code in the Advanced Editor, click Home -> Advanced Editor or you can click on View -> Advanced Editor. Let me know if it works?
Great...Thanks so much
You're most welcome Abdullah :)
Amazing Solutions..
We could create a dropdown for file path & Please make a video on rebuild data combination
Thank you Bhaskar and yes you could definitely create a dropdown for file path. Here is the link to the video for rebuilding the data combination: ua-cam.com/video/SLn5sAL3WnQ/v-deo.html
@@MissMicrosoft Thank You!
Great thank you for sharing
You're most welcome Faisal :)
Thanks!
You’re welcome!
Great video...
Glad you enjoyed Ankit :)
Hi thank you for this video and I have created File path, but renaming to original table 'ExcelFilePath' Object is missing after File.Contents. please let me know if we have the solutions for this.
Nice 👍👍👍
Thank you!
I would like to learn how to rebuild the query as it seems more secure than ignoring privacy/security protections.
Hi I've made the video, please check it out here: ua-cam.com/video/SLn5sAL3WnQ/v-deo.html
Thanks. What about where the file is in a SharePoint folder?
Hi Ian, it's a pleasure. You can most certainly create a dynamic file path in an Excel cell where the file is in a SharePoint folder. I will release a video on this for you, please hit the notification bell so you're notified for when the video is released.
@@MissMicrosoft Many thanks! I've subscribed to your channel with 🔔 notifications.
Hi Ian, I will definitely release the video, work is just sooo busy, I will release the video as soon as possible, thank you for your patience.
Hi Ian, please see link to latest video released showing how to do this: ua-cam.com/video/B-61Iqux0MU/v-deo.html
Hope it helps!
If the file based on cell path moves, will an error code appear/data cannot be refreshed?
I set my power query to get data from folder (YYYY) this folder has excel sheets named Q.P MM, and it filters out any excel sheet doesnot start with Q.P.
My question is can I apply this so i can change the source folder YYYY for different years as long as criteria Q.P MM still apply in all folders?
is it possible to use an IF statement to dynamic change the file path?
Hi Daniel, I’m not sure, IF you find out how let me know :)
If I have more than workbook in one folder and each workbook has a different names and I need to take one of those workbook to be as sample for rest of them and the upcoming workbook also what can I do
This video should help: How to Combine Multiple Files with Inconsistent Column Headers into a Single Sheet
ua-cam.com/video/SKskTCNiUIc/v-deo.html
@@MissMicrosoft could use a custom function as sample file instead or what about (table.combain) function 🤔
Hello @missmicrosoft I am suffering an issue. I am connecting a cell path in excel to power query but once I change the path of trhre file irt do not work. can you help?r
File names need to be the same? Oh no.
I have a few hundred TXT files. I need to import one by one to Excel. My query already separates the TXT files by topics (headers) and transforms those into MARKDOWN text, so I use PowerAutomate Desktop to copy parts of the text and paste each part in an appropriate FIELD of a document system.
The problem lies exactly in automating the change of source txt files used by PowerQuery.
I have a list of the txt files. All in the same path. I can make PowerAutomate change the filepath and filename (based on that list) in a cell, and need PowerQuery to change the query source based on that.
This seems really inefficient for Excel, surprised Microsoft hasn't streamlined this process