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 🚀🔥
@minelysp
6 ай бұрын
Hi it would be really helpful to learn how to rebuild data combination to prevent security issues when ignoring error
@MissMicrosoft
5 ай бұрын
Hi, please check out this video here on how to rebuild the data combination: kzitem.info/news/bejne/tIKkm6d3hWWIoYYsi=iFrKgFf9uFEGarFI
@affneto
Жыл бұрын
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!
@MissMicrosoft
Жыл бұрын
You’re most welcome 😊, I’m glad the video was helpful!
@gvinodnair
2 жыл бұрын
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.
@MissMicrosoft
2 жыл бұрын
Thank you Vinod for your support always 😊 Power Query is pretty awesome :D
@PMO247
Жыл бұрын
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!!!
@MissMicrosoft
Жыл бұрын
You are so welcome! I'm glad the video was helpful 😊
@MrDhunpagla
2 жыл бұрын
You are imaging ....... Thank you so much for sharing this & saving times of US ..keep Posting... 🙏🙏
@MissMicrosoft
2 жыл бұрын
Thank you Dhun, I'm so glad you find the video helpful! And I will keep posting, your support means a lot :)
@jmathew6988
10 ай бұрын
Very clear and concise. This is exactly what I am looking for. Thank you!
@Tommec100
2 ай бұрын
Thank you so much for this very clear explanation! 🙏
@mehtasanto
2 жыл бұрын
Wow! Nicely explained.. today only I saw your video... going forward,Will keep on following you.
@MissMicrosoft
2 жыл бұрын
Thank you so much Santosh! Appreciate the support :)
@eefginis4926
2 жыл бұрын
Realy good and clear explained! Helped me a lot! Thanks
@MissMicrosoft
2 жыл бұрын
You're most welcome and I'm so glad the video helped you eef!
@pradeep4645
9 ай бұрын
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.
@sandeshpadigela0
Жыл бұрын
Wow What wonderful idea, Appreciate.
@MissMicrosoft
Жыл бұрын
Many many thanks
@ajinkyaankush3648
Жыл бұрын
Nice and clear explanation of dynamic parameters. Subscribed to your channel 😊
@MissMicrosoft
Жыл бұрын
Thanks for the sub! :)
@huseyinburaktasci1638
2 ай бұрын
Thank you!!!
@entertainmenthub7700
10 ай бұрын
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
@eriknegron1047
2 жыл бұрын
Good video. Would be useful to have a video on rebuilding data combination :)
@MissMicrosoft
2 жыл бұрын
Thanks Erik! I will definitely make that video. Please hit the notification bell so that you know when it’s released :)
@MissMicrosoft
2 жыл бұрын
Hi Erik, please see the recent video that shows you how to rebuild the data combination, here is the link: kzitem.info/news/bejne/tIKkm6d3hWWIoYY
@gob2004
7 ай бұрын
@@MissMicrosoftThank so much for your "rebuild" clip.
@waelabughanimah3641
Жыл бұрын
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?
@MahmoudSamir7oda
5 ай бұрын
Thank you so helpful
@MissMicrosoft
5 ай бұрын
You're welcome!
@tlee7028
2 жыл бұрын
Thank you for your wonderful tutorials. How do I change data source when the gear icon is not available at Source in Query Settings?
@MissMicrosoft
2 жыл бұрын
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?
@rizkyaditya5523
7 ай бұрын
If the file based on cell path moves, will an error code appear/data cannot be refreshed?
@abdullah_alhathloul_
2 жыл бұрын
Great...Thanks so much
@MissMicrosoft
2 жыл бұрын
You're most welcome Abdullah :)
@Faisal63045
2 жыл бұрын
Great thank you for sharing
@MissMicrosoft
2 жыл бұрын
You're most welcome Faisal :)
@thebhaskarjoshi
2 жыл бұрын
Amazing Solutions.. We could create a dropdown for file path & Please make a video on rebuild data combination
@MissMicrosoft
2 жыл бұрын
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: kzitem.info/news/bejne/tIKkm6d3hWWIoYY
@thebhaskarjoshi
2 жыл бұрын
@@MissMicrosoft Thank You!
@ramandeepsr
Жыл бұрын
Thanks!
@MissMicrosoft
Жыл бұрын
You’re welcome!
@TempAccount-ij9zq
Жыл бұрын
I would like to learn how to rebuild the query as it seems more secure than ignoring privacy/security protections.
@MissMicrosoft
Жыл бұрын
Hi I've made the video, please check it out here: kzitem.info/news/bejne/tIKkm6d3hWWIoYY
@ankitbanka5628
2 жыл бұрын
Great video...
@MissMicrosoft
2 жыл бұрын
Glad you enjoyed Ankit :)
@eslamfahmy87
Жыл бұрын
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
@MissMicrosoft
Жыл бұрын
This video should help: How to Combine Multiple Files with Inconsistent Column Headers into a Single Sheet kzitem.info/news/bejne/tIGp0Yh5h5uGfJg
@eslamfahmy87
Жыл бұрын
@@MissMicrosoft could use a custom function as sample file instead or what about (table.combain) function 🤔
@danielpamamartins
2 жыл бұрын
is it possible to use an IF statement to dynamic change the file path?
@MissMicrosoft
2 жыл бұрын
Hi Daniel, I’m not sure, IF you find out how let me know :)
@sajidiqbal7035
2 жыл бұрын
Nice 👍👍👍
@MissMicrosoft
2 жыл бұрын
Thank you!
@iankr
2 жыл бұрын
Thanks. What about where the file is in a SharePoint folder?
@MissMicrosoft
2 жыл бұрын
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.
@iankr
2 жыл бұрын
@@MissMicrosoft Many thanks! I've subscribed to your channel with 🔔 notifications.
@MissMicrosoft
2 жыл бұрын
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.
@MissMicrosoft
2 жыл бұрын
Hi Ian, please see link to latest video released showing how to do this: kzitem.info/news/bejne/o2Nsl32nrqphgIo Hope it helps!
@rogeriopenna9014
Жыл бұрын
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.
@maximumaverage
Жыл бұрын
This seems really inefficient for Excel, surprised Microsoft hasn't streamlined this process
Пікірлер: 61