Episode 197: Power Query in Power BI

Episode 197: Power Query in Power BI

In 1990, the group Snap! release a song called "The Power". It would take Microsoft more than 20 years, but they eventually came up with a series of 'power' tools they built into Excel. Those tools later grew into Power BI--which is kinda like Voltron if you are old enough to remember. In this episode we discuss one of the first data manipulation tools in the set: Power Query. Before you start manipulating all those fun visualizations, you might need to get your data in shape. If you have a data warehouse, you are probably in good shape; however, for the rest of us, there is Power Query. This episode takes us through an overview and discusses in what cases you might have to dive into the code, or M language, when the GUI doesn't cut it.

The show notes for today's episode can be found at http://sqldatapartners.com/2020/04/15/episode-197-power-query-in-power-bi. Have fun on the SQL Trail!

Episoder(287)

Episode 271: Pass Summit 2023 Wrap-Up

Episode 271: Pass Summit 2023 Wrap-Up

This past November, Eugene and I attended the 2023 PASS Data Community Summit (aka PASS Summit) in Seattle, while Kevin headed down to Orlando for the Microsoft Live! 360 event in Orlando. Having no r...

29 Des 202338min

Episode 270: Medallion Architecture

Episode 270: Medallion Architecture

Moving up the ranks in the holy technology wars is the medallion architecture, and boy are we interested in getting your thoughts. Not since the 2008 Olympics and Michael Phelps' tenth of a second win...

21 Nov 202339min

Episode 269: Why Do I Need a Managed Service Provider?

Episode 269: Why Do I Need a Managed Service Provider?

In this Episode, Carlos talks about managed services and shares some of the benefits of working with an MSP, as well as potential cons.  The term manage services refers to the practice of outsourcing ...

19 Okt 202316min

Episode 268: AI and the Future of the Database

Episode 268: AI and the Future of the Database

We love hearing from our listeners!!! In this episode, a long-time listener asked about the future of AI in the data platform space. We thought this was a very interesting topic as Microsoft has been ...

28 Sep 202353min

Episode 267: Microsoft Fabric

Episode 267: Microsoft Fabric

All your data, all your teams—in one place. What am I? If you said Microsoft Fabric, you win! When I interned with Cisco Systems in 2000, I supported a platform called Unified Messaging. At that time,...

12 Sep 202343min

Episode 266: Working with Containers

Episode 266: Working with Containers

We're kicking off Season 7 with containers! Spinning up a VM may not be such a big deal anymore; however, most of us still have to request from another group one and wait. Even waiting on an Azure VM ...

29 Aug 202336min

Episode 265: WHY and What's Next

Episode 265: WHY and What's Next

Compañeros! In May, SQL Data Partners was acquired by Marathon Consulting.  There were many moving parts to get this done and we are excited to finally bring this news to the podcast.  In this episode...

28 Jun 202331min

Episode 264: Verified Backups

Episode 264: Verified Backups

A backup is only helpful when you can restore the backup. This should not prove to be overly shocking; however, normally we get the satisfaction of taking a backup and feel like all is well. Ideally, ...

12 Apr 202341min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
foreldreradet
treningspodden
rss-strid-de-norske-borgerkrigene
mikkels-paskenotter
jakt-og-fiskepodden
sinnsyn
takk-og-lov-med-anine-kierulf
hverdagspsyken
rss-sunn-okonomi
gravid-uke-for-uke
rss-kunsten-a-leve
rss-bisarr-historie
tomprat-med-gunnar-tjomlid
rss-kull
hagespiren-podcast
rss-var-forste-kaffe
fryktlos