Getting Crazy with the Power Query UI

Using Merge statements? Alex shows you how that can break the fold in Power Query! He's got you covered though and shows you a different way to approach it to make folding work! Using the UI!

Alex Powers:


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #PowerQuery #GuyInACube

[elrevesyelderecho]

Wait! This is on Power Query online. What about in PBI Desktop? When is going to be available? I like the look and field, icons, and design. Why it's not like this on Power Query within PBI Desktop?

[Dave_Bowman]

This is bananas. Just yelled at the screen over this one. Lol. Been building in desktop then migrating to power query on line for years. Totally missed this. Awesome job Alex! 😎

[PowerAppsTutorial]

Thanks guys! I'm a Power Apps developer guy who needs to learn more Power BI. 😁😁

[sukoi]

This is bananas. Been there used parameters and failed in services. This is 1 step ahead and solid.

[Anthony_Lecoq]

That is really great, thanks guys ;) How many item can we have in a list to use this List.Contains appraoch ? I had to try with a list of roughly 50000 item… it was just spinning. At the end I just kept the query unbroken until the end, and applied a merge at the end (breaking the folding) it became much more faster.

[zenisekd]

Any idea, when can we expect Power Query in Desktop catching up with Power Query in Service? it is seriously falling behind in so many ways.

[VikingGuard]

reminds me of ssrs reporting, where u could create a query from a list or a table to use as a parameter to a filter.

[hius]

Lists are such a powerful feature, need to use it more often over merges!

[MichaelsGaming]

Let's get some "Don't break the fold" t-shirts!

[stinaintx]

I am working on building reports where I connect to the sql database from my LMS. I’ve seen where those table columns appear in the various tables. This gives me some ideas on how I can better pull in information. Thanks for always posting great videos. ❤

[pawarbi]

#DontBreakTheFold 👏👏 Didn't know about In 🤯 Isnt there a limit on how many items can be included in the IN, like 240 or something?

[douglasbrito]

great tip, thanks. talking about about how enable query folding when using Azure Databricks connector ? Regardless how I select data the View ?Native Query is disabled.

[wmcnabb]

Awesome video gentleman. I now have something I can show clients this concept...

[Darksirius]

When this 2 guys joins the result is a great Video. Thanks to be so awsome.

[zoranmilokanovic]

When can we expect "In.." and "Not in..." options in Text filters of Power Query Desktop version?

[TheNms]

I need those fancy PQ online features in desktop ASAP!! :)

[SamuelRoshan]

This is REALLY amazing!! Has this feature always been there in Power Query?? :o

[madisonbreland]

There are many instances where I have merged separate queries for the sole purpose of filtering, but didn't know of this list method. What is the benefit of using this method? You guys say not to break the fold, but why not?

[Abiah]

Thanks for sharing! This is REALLY amazing!

[pabeader]

That's bananas!!!! Lists for the win.