QueryPower's profile picture. Where the 'M'agic happens

All things Power Query, check out the Podcast

Podcast
http://powerquerymagic.podbean.com
also on Spotify and Apple Podcast

Power Query Magic

@QueryPower

Where the 'M'agic happens All things Power Query, check out the Podcast Podcast http://powerquerymagic.podbean.com also on Spotify and Apple Podcast

The podcast series now hit 14,000 downloads Thanks for listening everyone 😀 No new episodes planned yet.. but who knows what the future holds. powerquerymagic.podbean.com


GPT4 Magic!

This post is unavailable.

Power Query Magic reposted

Mac Power Query is missing "From Table" and "From Folder". @smozgur brings that functionality to Mac Excel in a free VBA add-in. mrexcel.com/board/excel-ar…

MrExcel's tweet image. Mac Power Query is missing "From Table" and "From Folder". @smozgur  brings that functionality to Mac Excel in a free VBA add-in. mrexcel.com/board/excel-ar…

If you’re following along here then you might like some of these podcasts: pbi.guide/resources/#Pod… Any of your favourites on there?


Power Query Magic reposted

1/ Struggling with Power Query functions? 🤯 Exciting news....! Introducing PowerQuery.How 💥 The website to learn more about Power Query M functions. Let's dive in! 🧵


Power Query Magic reposted

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


Interesting approach

Got the Formula.Firewall error in #PowerQuery and don't want to rework all your existing queries? There is a quick fix for it: wp.me/p6lgsG-2tF #PowerBI



Power Query Magic reposted

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! youtu.be/IHgHvHaWfpM #excel #PowerBI


Power Query Magic reposted

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? 📆 youtu.be/sCVQUXS8WwY

Rickmaurinus's tweet card. Create Date Table with Dynamic Language in Power Query

youtube.com

YouTube

Create Date Table with Dynamic Language in Power Query


Power Query Magic reposted

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 - guyinacu.be/pqsql

GuyInACube's tweet image. 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 - guyinacu.be/pqsql

Power Query Magic reposted

Transform Column Names in Bulk in #PowerQuery from @Rickmaurinus buff.ly/3x9vvOM #PowerBI


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 powerquerymagic.podbean.com/e/the-one-with… youtu.be/3IPFdtFi_UI

QueryPower's tweet card. The One with Rick de Groot

youtube.com

YouTube

The One with Rick de Groot


New episode out tomorrow


Loading...

Something went wrong.


Something went wrong.