41 - How to Refresh Queries in Excel Power Query

[@navinm3096]

Hello Sumit, I've watched all 41 power query training videos and learnt a lot. Just want to say that your videos are very clear to understand and well structured, probably the best training videos I've come across on youtube. These videos were uploaded about 4 years ago, but are still so relevant today and helpful for those struggling to figure out how to use power query. A very big thanks, this will definitely help me to be more productive at work. 🙌

[@Swizzletwice]

July 2024 -- I finished all 41 videos in this PQ course. Imo, it's among the very best courses I've ever taken in my entire life. This course is very well-structured in the form of short videos which emphasize a single aspect of PQ. By the time I was done, I won't say I'm an expert, but I have an excellent understanding of PQ. Everything is well-explained. There is a practice file for every video (except #40). I took extensive notes. If I want to review a concept, it's easy to find the concept and the file and practice it again. Sumit Bansal has a nice voice, good pacing, and doesn't meander. The emphasis is entirely on the content with no irritating picture-in-picture or gimmicks. The course is 4 yrs old as of this date and is still as relevant today as the day it was produced. Less than a handful of things were different in my newer version of PQ, and it was easy to figure out and carry on. This is all available for free and for some of the best teaching available. Ten gold stars to Sumit Bansal, the talented instructor & creator of the course.

[@trumpexcel]

Thank you so much for the kind words. I am happy you found the course helpful 🙂

[@nazarkamal8831]

Thanks for almost entire things about Power query all package in one channel ❤❤❤❤ truly learned a lot Thanks TrumpExcel

[@grzegorz2852]

I did all you videos in only 4 days, great examples, super great source of knowledge, thank you very much. I have learned a lot from this course, which was so interesting. U have been doing a great job. For me now it's time for VBA course

[@udayteja6595]

This is the last video of the playlist. Completed watching all the videos in the playlist. Really very informative videos, and helpful. Thankyou very very much for the content. I have learnt many new things from this series of power quires.

[@redherring4119]

Great course. Straight to the point but very comprehensive. Would be nice if you did more courses on other features such as Power Pivot and PowerBI.

[@tabishkhan9559]

One of the Best Playlist 1 Needs to follow if he is interested in Learning Power Query. Thanks Alot Sumit

[@trumpexcel]

Thanks for the kind words Tabish

[@sravankumar4860]

Hi Bro. I really love your video. I learnt a lot from ur lectures. I see less videos these days truly missing. Hope u bounce back and do lot more videos to help others😢

[@Thor_Underdunk_Caballerial]

I'm impressed with the concise, yet complete nature of this video and your effective language skills. The production is decent also, top stuff, very helpful. Thank You.

[@alparkson5494]

I have been looking for this solution for over a month! Thank you for your instruction. So easy to understand.

[@margad-erdeneboldbaatar4704]

Thanks so much for this all free course. I just finished all your Excel courses. These lessons are very simple explained, easy to understand and very practical.

[@LinhPhan-sk6ti]

Learned a lot from the whole series. Thank you very much. Keep up the good work :)

[@sohaybemad623]

Best PQ playlist on youtube♥

[@IARM1]

Thanks for so valuable playlist.

[@AnushkaStatusVideos]

Hi Sumit Bansal, Had seen all the 41 videos of this power query play list, all are well explained in detail, thanks for your time and effort in creating this kind of a very useful playlist. One request, is it possible for you to create a playlist for POWER PIVOT with DAX FORMULAS from basic to advanced as after completing Power Query, we have to learn DAX, then only we can get in to Power BI, I think. This is my humble view and request. If possible please upload, else ok. Anyways, thanks for your contribution to Excel and its allied subjects, May God bless you with good health and happiness always. Stay Safe and Stay Healthy. Thanks

[@michafabich9213]

great course, watched from beginning to end!

[@rtrbs8383]

Awesome Sir I have finished all your playlist....Hope we will have Part 2 of Power Query.. Thank you Very Much

[@jing7350]

Very helpful course. It's straightforward and well structured. Thank you!

[@kewal229]

Short and simple.. Very useful trick for self learners.. Thank you so much. 🙌🏻

[@bessyvalayil1831]

Very useful and well explained. Thank you... !

[@poruatokin]

Congratulations and thanks - your tuition here saved me a huge amount of time. Really excellent stuff.

[@vitalisifiokamasi2679]

Honestly, great videos and explanation of concepts

[@FsoOmar]

Thank you very much Sumit.👏

[@prudhvilanka]

Graet Insights Brother..!!

[@arsalankahan568]

Thanks so much very helpful 😀

[@faithfinancemath]

Thanks for the course.

[@user-yx6tn3rd3q]

Very useful If Target.Address = … Thank you!

[@DerekMorgan1]

Thanks, this is a very good course

[@study4734]

This is helpful.

[@alexrosen8762]

Very useful tutorial.Thanks :-)

[@russo6770]

Thank you!! very useful

[@RamachandranS20]

Thank you so much. Exactly what I need.

[@AmiSikorski]

this is great! i have an issue with my query. When i remove a line from my data source workbook, it stays in my query workbook. I cannot figure out how to get that row to remove from my query also

[@loveprosen]

Very helpful!!!

[@sivas9443]

wonderful 41 videos and waiting for more . !!! thanks a lot

[@allanjunior9198]

Dont know if anyone gives a shit but if you're bored like me atm you can watch pretty much all the latest movies on instaflixxer. I've been streaming with my brother for the last few months xD

[@caspianayaan1502]

@Allan Junior Yea, I've been watching on instaflixxer for since november myself =)

[@rexjuelz7229]

@Allan Junior Yup, I have been using InstaFlixxer for months myself :)

[@dustinjamison3031]

@Allan Junior Yup, I've been using instaflixxer for months myself :)

[@hendrixnathan1008]

@Allan Junior definitely, been using instaflixxer for months myself =)

[@luishaka88]

lifesaver!!

[@Sk-ew7cn]

THANKS A LOT 🙏

[@TheMthegr8]

This is super impressive. I have one question though - my source data in excel is connected to an online application. When I click on refresh button every month it refreshes my data with live status as at that moment on the application. Now, if I create power query out of my source data, and load data sheet from power query into same workbook, will my power query data be also refreshed whenever I refresh my source data? Pls reply.

[@mikelennon1078]

What is the best way to update the records in the source table/sheet directly form the Power Query ( like, adding records, deleting a record, editing,.....). Can we make a column properties ( one or more columns) a Hyperlink that be clicking it, a custom data entry form be opened to add, deleted or update the record/s in the source tables?

[@meteora8888]

thx for the video. one question. i update my source data which powerquery pulls into my data model but the changes i made in the source table flow thru via powerquery no matter what i do. any ideas where im going wrong?

[@CarlitoAugust]

how can you make the dropdown to select multiple options so the filtered table works for more than one selection? is there a way to make it work with several filters?

[@briandennehy6380]

Hi Sumit, is it possible to create a macro that runs daily to refresh the connection without any manual intervention to start the macro?

[@sohaybemad623]

Sorry i have a question, so isn't it better to just use the right click and hit refresh instead of right a VBA code and then you have to run it also!?

[@lionels839]

I believe data/refresh all can refresh both queries and pivot tables. Right?

[@niritcaspi9013]

is there a way to refresh (by office scripts) a few power query connections sorted ?i was not able to do "action recorder" for power query , so i have to write it , can you help?

[@ExceluniForAll]

very gooood

[@abuena73]

you can still save your file as xlsx even though you have vba script? is macro-enabled worksheet can run under file type xlsx???

[@grantw1465]

Thanks for this and I was wondering if you can automate refreshing multiple excel documents. I.e. I update all my source files and then I run one "parent" query (using PQ), save and close it and then open another, reliant on the previous parent document, and run another query here. Then I have multiple "child-like" queries that I run separately as they feed off these initially refreshed queries (parents). Point being, is there a way to automate this entire process instead of manually opening each document and running the queries manually? I would suppose one could combine refresh on opening the "child' documents but can one manipulate it so that the "parent" document/s are first completed, one after the other, in order and then the children opened and set to update on opening?

[@rashidkhan8161]

Please refer best book for learn M language

[@ShaibulHoqueMozumder]

THANK YOU SIR

[@hiezellechan31]

I have a question. what if i update my raw file, how can i make sure it is updated on my power query ?

[@lalitchavan519]

I appended 4 sheets to create a data model in power query and created a pivot to fetch all data at once. But when i update sources data and refresh data model, there are no changes. And pivot goes blank after refresh. Can you help please.

[@AmP_BYD]

in my excel, when query properties is selected, only the Query Name and Description are shown. All other options like, refresh control, server Formatting are absent. Is there any way to enable them?

[@apsarshaik9407]

Hi sir, thank you for your videos, which is vary helpfull, i have one challange.. everyday i have to send the cdr (calls count) report every hour, i have tried with power query but the problem is wen ever i replace the data in table the power query piot counting histry(yesturday) count also need help on this plz

[@jodhvirsingh8677]

Hello Apsar. I think you would need to make 2 tables (since you need two days data). Table 1 contains todays data and Table 2 contains yesterdays data. Now tomorrow your data needs to shift from table 1 to 2 and new data needs to be added to Table 1. What you can do is record a macro for this and then erase all the hardcoded elements in the vba. Then when you refresh the data your table 1 data would go automatically to table 2 and new data would get entered in table 2. Then refresh the pivot table. Hope it helps.

[@kalmkrew]

The table is connected but when I add data to the source is doesn't show the new data after refresh

[@v11890]

Can we link Query of one workbook to other workbook.. Here I'm talking about linking (Not copy paste ) and when Query in source file is updated then Query of destination workbook should also get updated

[@alterchannel2501]

The only bad thing about the Selection Change is that you don:t have the "undo" in excel

[@WealthofStocks4]

Sir ek vedio banao refresh karte hi permission karne ke liye mag raha wo hum kahan se sahi kar sakte hai

[@emre-cil]

king

[@harshitakumar-l4p]

power BI and power query are same?????????????????????/

[@loidaasar487]

in the zipped file, why don't you have the practice files for playlist no. 40?

[@vasimuddinsheikh3766]

You can make multiple folder containing empty files that's the only requirement for that video.....

[@nvcworld6423]

How resolve connection issues by VBA ? Every time need to click on connect button 🙄🙄🙄🙄

[@madhusudanbehera1651]

does not refresh the query table

[@madhusudanbehera1651]

code = ActiveWorkbook.Connections("Query - invoked_function").Refresh does not work