Power Query Magic

Where the 'M'agic happens

All things Power Query, check out the Podcast

Podcast
on Spotify and Apple Podcast

[Power Query Magic @QueryPower]

Whoo-hoo!

[Power Query Magic @QueryPower]

The podcast series now hit 14,000 downloads

Thanks for listening everyone 😀

No new episodes planned yet.. but who knows what the future holds.

https://t.co/XQ3coQObDW

[Power Query Magic @QueryPower]

GPT4 Magic!

[Bill Jelen @MrExcel]

Mac Power Query is missing "From Table" and "From Folder". @smozgur brings that functionality to Mac Excel in a free VBA add-in. https://t.co/0nZCdw7UI4

[Power Query Magic @QueryPower]

If you’re following along here then you might like some of these podcasts:

https://t.co/5m8hDt9DAJ

Any of your favourites on there?

[Rick de Groot @Rickmaurinus]

1/ Struggling with Power Query functions? 🤯 Exciting news....! Introducing https://t.co/tU56GkW6YB 💥

The website to learn more about Power Query M functions. Let's dive in! 🧵

[Chandeep Chhabra @chandeep2786]

Here is a mind blowing 🤯 @MSPowerQuery trick.
➜ When wrapping your PQ Code, start with a dot (.)
➜ Navigate the list of functions using the arrow keys.
➜ Once you've picked up the function hit tab. This way it won't eat into your existing function.
#PowerQuery #PowerBI #Excel

[Power Query Magic @QueryPower]

Interesting approach

[Imke Feldmann @TheBIccountant]

Got the Formula.Firewall error in #PowerQuery and don't want to rework all your existing queries? There is a quick fix for it:
https://t.co/eML3zXqqBJ
#PowerBI

[Power Query Magic @QueryPower]

Apple, Spotify etc..
Podbean: https://t.co/KiQDlhCYNb

YouTube: https://t.co/2QUmI2xOXa

[Power Query Magic @QueryPower]

New Episode 🎧
Miguel Escobar of "M is for data monkey" fame and its recent completely re-written version "Master Your Data"
Now a Product Manager at Microsoft aiming to #PowerQueryEverything

The one with
@EscobarMiguel90

Links⏬
#PowerQuery

[Power Query Magic @QueryPower]

Apple, Spotify etc plus YouTube https://t.co/Qy5Ns58NBG

[Power Query Magic @QueryPower]

New Episode 🎧
Author of Supercharge DAX, trainer, speaker and all-round good guy, Matt is a Sydney based pillar of the Power Pivot / Power BI community.

Any greater achievement than coining the phrase "The Collie Method?"

The one with @ExceleratorBI
Podcast and YouTube ...

[Chandeep Chhabra @chandeep2786]

If you perused the Advanced Editor in #PowerQuery you'd easily be able to spot the 'each' & '_' keywords.

Ever wondered what are they and how do they work? No?

Here, watch this! https://t.co/yJWNgysMkD

#excel #PowerBI

[Chandeep Chhabra @chandeep2786]

Here is some List Love in #PowerQuery for the weekend.
https://t.co/gWEgrWXqOP
Enjoy.

[Rick de Groot @Rickmaurinus]

Every developer knows this. Supporting multiple languages can be a pain. So what to do if you need a calendar table that supports multiple languages? 📆

https://t.co/k3Xgd0ZBfP

[Guy In A Cube @GuyInACube]

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 #PowerQuery do it for you to move your project forward. @PatrickDBA shows you how! #PowerBI

Watch on YouTube - https://t.co/SXXZGfPDTl

[Power BI Weekly @PowerBIWeekly]

Transform Column Names in Bulk in #PowerQuery from @Rickmaurinus https://t.co/pgxi8oCRwt #PowerBI

[Power Query Magic @QueryPower]

A new episode with @Rickmaurinus ⚡️ 👨‍💻! Great to chat with Rick and he sets a new record for the "Just a M inute" game

Spotify, Apple Podcasts, Podbean etc and YouTube

https://t.co/xahTuDI8Jk

https://t.co/M8NgQbfX4x

[Power Query Magic @QueryPower]

New episode out tomorrow

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

TIL that @wynhopkins has a great #PowerQuery Youtube channel called PowerQuery Magic. https://t.co/U3SoiYt47A