fbpx

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.

Can’t create a Relationship? Time for a surrogate key in Power BI!2024-05-02T07:00:45-05:00

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

Include in Refresh can trip you up within Power Query2024-03-14T07:45:14-05:00

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

Can you use Power Query Dynamic M Parameters for multi-select?2023-06-28T07:26:52-05:00

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/

Setup a Reverse Hybrid Table without using Tabular Editor for Power BI!2023-04-05T08:43:57-05:00

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

Visually see where you BROKE the fold in Power Query2023-03-23T08:15:28-05:00

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/

Getting Crazy with the Power Query UI2023-03-01T09:05:52-05:00

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!

A Power Query tip for you2022-12-14T07:15:12-05:00

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!

Let Power Query write your SQL for you!2022-10-10T03:54:23-05:00

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!

A Power Query feature you may not know about!2022-10-06T07:53:53-05:00
Go to Top