[Solve] – Fix the column names in Excel export from Power BI Desktop Report

ByHariharan Rajendran

[Solve] – Fix the column names in Excel export from Power BI Desktop Report

This blog post explains you that how to fix the column name mismatch in the Power BI visual export. This is not a major issue for most of us but sometimes user might complain about the column name mismatch when they directly compare the UI result with excel export.

How to reproduce it?

This issue occurs in Power BI Desktop report. This issue will occur when you use the direct measure (implicit measure) in the visual.

Scenario

I have table called Dummy where I have 2 direct columns – Department & Sales. I am just creating a simple and visual and exporting the visual data into csv using export data option in Power Bi Desktop itself.

 

The result of csv file will have proper column names.

Try publishing the same report to service and export there into excel and we will get the below column names.

The name of Sales column is changed into “Sum of Sales”. The default summarization of this column is SUM so the name of column has changed.

Note- The names will be same if we export into csv both in Desktop and Service.

Solution

The solution is very simple. Create an explicit measure using DAX and use that measure in your visual.

Created a new DAX measure called SalesValue and used that measure in visual. If we try to export into excel then we will have proper name as like below.

Happy Learning. Comment if you have any other approach.

About the Author

Hariharan Rajendran author

Hariharan Rajendran is a MVP in Data Platform and Microsoft Certified Trainer with 10+ years of experience in Database, BI and Azure platforms. Hariharan is also an active community leader, speaker & organizer and leads the Microsoft PUG (Power BI User Group – Chennai), SQLPASS Power BI Local Group – Chennai and an active speaker in SQL Server Chennai User Group and also a leader in Data Awareness Program worldwide events. Hariharan also frequently blogs (www.dataap.org/blog), provides virtual training (on ad-hoc basis) on Microsoft Azure, Database Administration, Power BI and database development to worldwide clients/audience.

Leave a Reply

8 + 2 =