How To... get your data column names to show up properly in Power BI


How to ...

Hey there Reader,

This week's post is all about one of the most common data cleaning activities that has to be done in Power BI using Power Query Editor... getting your column names to actually BE your column names.

Sometimes, when you connect to data like an Excel sheet, Power BI can't read the column names in your Excel sheet properly (it's not your fault, it's Power BI's) so you have to help it out a little bit...

How To... get your data column names to show up properly in Power BI

Not loving How To Use Power BI in your inbox anymore? Unsubscribe here.

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

This Week:

Promoting Column Headers

When you have to help Power BI read data.


More Power Query Posts

(For some more data transformation posts)

Intro to Power Query Editor

Get to know what you're looking at when you open up Power Query Editor.

Splitting Columns

How to separate data into multiple columns.

Merging Columns

Bring data from different columns into one.

Add a Column from Examples

Make a new column based on an existing column.

Documenting your Power Query transformations

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

All Recent Posts:

Check out the How To Archives

All the posts (so far).

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



Subscribe to Joe Travers