Dynamic M parameters in Power Query isn't anything new. However, Patrick was challenged with using them to allow for multi-select and "select all" with a slicer in a Power BI report. Will he succeed? Dynamic M query parameters in Power BI Desktop https://learn.microsoft.com/power-bi/connect-data/desktop-dynamic-m-query-parameters
Hybrid Tables can be very useful for mixing archived data with current data. Pat Mahoney joins Patrick to show how to configure a Hybrid Table within a Power BI dataset without using Tabular Editor. Just some straight "M"agic. Hybrid Table Documentation: https://learn.microsoft.com/power-bi/connect-data/service-dataset-modes-understand#hybrid-tables Connect with Pat Mahoney: https://twitter.com/mahoneypa https://www.linkedin.com/in/patrick-mahoney-3138526/ https://www.youtube.com/@hoosierbi5669 https://hoosierbi.com/
Rule #1 - DON'T BREAK THE FOLD! There is an amazing feature that lets you see where this fold was broken, and I'm guessing you didn't even know it was there! Adam shows you where to go. Query plan for Power Query (Preview) https://learn.microsoft.com/power-query/query-plan
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: https://twitter.com/notaboutthecell https://www.linkedin.com/in/alexmpowers/ https://itsnotaboutthecell.com/
You probably know that you can concatenate strings in Power Query. Not big news there. But do you know how to change the order of how things are concatenated? Patrick shows you how!
We tell you to push your transformations upstream as much as possible. But you don't know how to write SQL. That's ok, let Power Query do it for you to move your project forward. Patrick shows you how!
We thought everyone knew about this Power Query capability! At the Power Platform Conference, we found that many did not. Well, we want to help make sure everyone is aware so that you can reuse your awesome Power Query work in Power BI or Excel!
You can do amazing things in Power Query! Maybe you think to create a function. But do you really need a function for that? Or is it over complicating things?
Have you published your Power BI report to the service, refresh the data, and the visuals go blank? Patrick may have an answer for you. Troubleshooting refresh scenarios https://docs.microsoft.com/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios Data types in Power BI Desktop https://docs.microsoft.com/power-bi/connect-data/desktop-data-types Damu Venkatesan: https://twitter.com/vdamu https://www.linkedin.com/in/damuvenkatesan/
We thought that DAX was the thing in Power BI. Alex proves the M-M-Magic is really with Power Query! If you wanted to be blown away but what Power Query can do, this is the video for you! Connect with Alex: https://twitter.com/notaboutthecell https://www.linkedin.com/in/alexmpowers/ Power Query folding https://docs.microsoft.com/power-query/power-query-folding 30 Day Challenge: Query Folding https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N Power Query [...]
