Dynamic Query Referencing in Power Query 🚀| Using #sections in Power Query

In this video, we will be discussing dealing with multiple Queries. How can we deal with & work with them using Dynamic Referencing!

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== CHAPTERS =====
0:00 Intro
0:24 Introduction to the Case
1:41 Getting all the Queries Dynamically
2:51 Converting the Records into Tables
3:51 Picking up the Right Queries
5:15 My Courses

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[GoodlyChandeep]

*Note - this doesn't work in Power BI but only in Excel PQ environment.*

[vacilando]

You are one of the most productive content creator in this platform, I learned so much from you. Thank you

[EricHartwigConsulting]

This is awesome! I love how dynamic this is!

[Piyush.A]

Excellent video, never imagined this would be even a thing, and yet you're once again diving deep into it!

[roywilson]

Great video; I can see so many cases where this will be a useful tool to have.

[syrophenikan]

Flipping Thanks so much for this. This will help in so many ways. Great job!

[karimallahwala]

Thank for sharing and explaining that very helpful „section“

[damionc]

I am always always learning something new and different with your videos. This is great. 👍🏽

[jessontvarghese]

There is no doubt. This is superb coool and awesome overloaded. Thank you.

[davidfelipepenaguardiola]

Amazing and very very usefull solution. Thanks a lot, Mr Chandeep :)

[ALex-fpzx]

Thanks, wery nice 👍 Dynamizing is always cool!

[arunkumarkesavan]

Cool of course it will help us... Super Awesome!!!

[IvanCortinas_ES]

This is very useful in daily work. Thank you Chandeep!!!

[GeertDelmulle]

Good stuff, Chandeep!
Now, I would use a template for all customers, put the files in a folder and work from there, avoiding the issue all together.
For several input streams towards, I would make 1 folder + query per stream and combine the streams manually down the —er— flow.
Still a good trick and good to know.

[jorstube]

wonderful brother!!! a few days ago I was wondering how to get the name of the query in another query and you just did it; You are a teacher; I was working with a file where the tables are on different sheets and I needed to do a summary in the same book but I didn't want to load tables separately... now I'm going with this improvement. Thank you!!!

[aniljaggarwal]

आप पावर क्वेरी में एम कोड सीखने का आसान रास्ता बना रहे हो 😊

[RyanLeishman]

That’s pretty useful actually!

Would the expand button on the column header then expand and append all tables?

[odel_leal]

Great information ℹ️ Ypur content is very valuable. I appreciated. Thank you.

[vishalvadalkar]

Nice to connect-need to know how can we minimize query refresh time-Source data same excel-4-5 tables

[vinhxd]

In case of I have a table from query naming Query_Tab1 in excel file 1. Then I add the extra some column beside of Query_Tab1. I want to get the new data, including the Q_T1 and news extra column to a new table nam wing Tab2. Then combine Tab2 to my report.. Many thanks