Hi ,

How are you doing?

Last week, I did a bit of a reality check on how Claude works with Power BI, and a lot of you asked the obvious next question:

Okay… but how do I actually connect Claude to Power BI?

So this week’s video is exactly about that.

I show you the simplest way to connect Claude Desktop with Power BI Desktop, what you need to install, where the MCP file sits, and how to set it up the right way so Claude can actually start interacting with your model.

The nice part is, it’s not some long technical setup. You can get it done in about 10 minutes.

So if you’ve been curious to try it yourself, this video will get you there.

Add Columns in a Nested Table

Here’s a simple trick to go inside a nested table, calculate something from one of its columns, and add the result back as a new column in that same nested table.

A quick way to split values into rows

Just like you split values into columns, Power Query also lets you split them into rows. Super useful when one cell contains multiple items.

The PQ festival deals close in 3 days.

Just a small reminder from my side because I know many of you have been trying to get better at Power Query, and I don’t want you to miss this while it’s still open.

A lot of people use Power Query only through the buttons.

And that’s fine in the beginning.

But the real power of Power Query comes when you start understanding the M language behind those steps. That’s when you can clean messy data, fix tricky files, and build queries that don’t break every time the source data changes slightly.

That’s exactly why I put these resources together.

Option 1 - If you want the full learning path, go for the Complete Power Query Mastery Bundle.

You get the M Language Course, PQ Function Library, Power Query eBook, 60+ Plug-n-Play Recipes Handbook, Companion Lessons, and Exercise Solution Videos.

Normally, the bundle costs $665, but during {M}ay, it’s $169 (and for Indian Students ₹10,190) + taxes.





Option 2 - And if you don’t want to jump into the full M course yet, the Power Query Starter Pack is the lighter option.

You get the book, Companion Lessons, Exercise Solution Videos, and 60+ Plug-n-Play Recipes Handbook.

Normally, if bought separately, these cost $267, but during {M}ay, it’s $49 (and for Indian Students ₹2,990) + taxes.

Both special deals close in 3 days, so don’t procrastinate further.



Our consulting company Goodly Insights completed 2 years on 16th May