How to ... get started with Power Query in Power BI


How to get started with Power Query

Hey there Reader,

One big advantage that Power BI has over some (not all) other data dashboard platforms is that it has Power Query editor built into it and allows you to clean, transform, and do just about whatever you need to structure your data just so for visuals and dashboards.

Power Query activities can be basic, like removing columns or rows you don't need or renaming columns to more advanced like unpivoting columns, renaming columns in bulk, or just about anything you can think of.

This post covers the basics of Power Query to get you started, and you can take a look at the Power Query subject category to see what I've posted so far about what you can do in it.

An Introduction to Power Query Editor.

Not loving How To Use Power BI in your inbox anymore? No problem.

Unsubscribe here.

(because you should only get these emails if you love them and find them useful!)

This Week:

An Introduction to Power Query

Get started with the tool that can do anything (with enough time).


Recent posts you may have missed:

DAX: MAX


Check out our How-To Subject collections

Bar Charts

Making, formatting, fixing, even adding benchmark lines to bar charts.

DAX

Making, formatting, fixing, even adding benchmark lines to bar charts.

Hot (& Fresh) Tips!

Making, formatting, fixing, even adding benchmark lines to bar charts.

More from Joe (me)!

You can learn from me in a workshop

I run friendly and informative Beginner and Advanced Power BI workshops. Get started (or level up if you already know the basics) so you can start reporting insights from your data ASAP! Hit the reply button on this email and let's chat.

You can pick my Power BI Brain

After 7+ years of using Power BI daily, I've come across (and sworn at) a LOT of error messages, things that don't make sense, and other challenges. You don't have to go through it all too... you can get me to help you through the challenges. Don't spend hours/days/weeks being frustrated... I've already gone through that FOR you. Talk to me. I can help.

Take care everyone,

Joe.

TraversData.com | LinkedIn | Instagram



Silly Spreadsheet Merch

Hey, I also spend a lot of time in spreadsheets (don't we all) and had a fun idea for little stickers and magnets and shirts....

Give a Sheet (Magnet)

(You can give a Sheet on way more stuff too)

In Deep Sheet (Mug)

(Get into more deep sheet on other stuff too.)

Subscribe to Joe Travers