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 🚀🔥

Very clear and concise. This is exactly what I am looking for. Thank you!

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!

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

10 ай бұрын

You’re most welcome 😊, I’m glad the video was helpful!

@artemis2848

2 ай бұрын

@@MissMicrosoftHello, would it be possible to contact you please?

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

@artemis2848

2 ай бұрын

@@MissMicrosoft I found a bug in your system. Indeed, if you mark text in the cells above the first table “SalesData”, and if you add columns only in January. Each time you update, it will shift the text to the right, and if you update in February, it will also do the same thing. As a result, the text in the cells will move far to the right of the tables if you update in succession. Can I show you some screenshots or something?

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 :)

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

9 ай бұрын

You are so welcome! I'm glad the video was helpful 😊

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 :)

Nice and clear explanation of dynamic parameters. Subscribed to your channel 😊

@MissMicrosoft

Жыл бұрын

Thanks for the sub! :)

Hi it would be really helpful to learn how to rebuild data combination to prevent security issues when ignoring error

@MissMicrosoft

2 ай бұрын

Hi, please check out this video here on how to rebuild the data combination: kzread.info/dash/bejne/hYCil9V6fJa9nrQ.htmlsi=iFrKgFf9uFEGarFI

Wow What wonderful idea, Appreciate.

@MissMicrosoft

Жыл бұрын

Many many thanks

Great thank you for sharing

@MissMicrosoft

2 жыл бұрын

You're most welcome Faisal :)

Great...Thanks so much

@MissMicrosoft

2 жыл бұрын

You're most welcome Abdullah :)

Thank you so helpful

@MissMicrosoft

2 ай бұрын

You're welcome!

Thanks!

@MissMicrosoft

Жыл бұрын

You’re welcome!

Great video...

@MissMicrosoft

2 жыл бұрын

Glad you enjoyed Ankit :)

Nice 👍👍👍

@MissMicrosoft

Жыл бұрын

Thank you!

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: kzread.info/dash/bejne/hYCil9V6fJa9nrQ.html

@gob2004

4 ай бұрын

@@MissMicrosoftThank so much for your "rebuild" clip.

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.

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: kzread.info/dash/bejne/hYCil9V6fJa9nrQ.html

@thebhaskarjoshi

2 жыл бұрын

@@MissMicrosoft Thank You!

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?

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?

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

If the file based on cell path moves, will an error code appear/data cannot be refreshed?

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.

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: kzread.info/dash/bejne/hYCil9V6fJa9nrQ.html

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 kzread.info/dash/bejne/hX-nzbZ8fsy7ecY.html

@eslamfahmy87

Жыл бұрын

@@MissMicrosoft could use a custom function as sample file instead or what about (table.combain) function 🤔

is it possible to use an IF statement to dynamic change the file path?

@MissMicrosoft

Жыл бұрын

Hi Daniel, I’m not sure, IF you find out how let me know :)

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: kzread.info/dash/bejne/dGFqk6uqpduWfbg.html Hope it helps!

This seems really inefficient for Excel, surprised Microsoft hasn't streamlined this process