Leverage Power Query Parameters with Power BI Paginated reports
You've seen how you can use Power Query within Power BI Paginated reports. Now Patrick shows you how you can leverage parameters to drive interactivity!
Can’t create a Relationship? Time for a surrogate key in Power BI!
This looks at a scenario of a hierarchy but the child ID repeats and we can't create a relationship on it. Adam looks at how you could use a surrogate key to get a relationship in place so you can build your Power BI report.
Include in Refresh can trip you up within Power Query
You disabled Include In Refresh in Power Query, but it's still being used? And you still need to provide credentials for your Power BI Semantic Mode? What?!? Adam breaks down what's going on. Managing query refresh in Power BI https://learn.microsoft.com/power-bi/connect-data/refresh-include-in-report-refresh
Can you use Power Query Dynamic M Parameters for multi-select?
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
Setup a Reverse Hybrid Table without using Tabular Editor for Power BI!
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/
Visually see where you BROKE the fold in Power Query
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
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: https://twitter.com/notaboutthecell https://www.linkedin.com/in/alexmpowers/ https://itsnotaboutthecell.com/
A Power Query tip for you
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!
Let Power Query write your SQL for you!
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!
A Power Query feature you may not know about!
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!