cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DanBusIntel Member
Member

Power Query keeps case detail but Power BI loses case detail

Hi,

I saw something odd with a simple dataset today.

 

I have an excel file with the following contents:
case1.JPG

The first column contains simple characters. The second column contains a description of the first column.

 

When I load the excel file into Power Query I see the datset like this:

case1.JPG

All looks ok in Power Query.

 

When I load from Power Query to the Data Model (Power BI) I see this:
case1.JPG

 

You will notice that characters are appearing in Power BI as lowercase but are uppercase in the source/Power Query.

Can anyone explain why the character's case are behaving in this way?

Thanks.

3 REPLIES 3
Community Support Team
Community Support Team

Re: Power Query keeps case detail but Power BI loses case detail

Hi @DanBusIntel

Same is happening for me.

This is by design. Power BI workbook uses a case insensitive language setting. As a result, strings in the same column which differ only by cases will be consolidated into a single string depending on whichever happens to be imported first. Query Editor UI displays the strings in the original case before the Import, Data View shows the strings after the Import.

 

Best Regards

Maggie

DanBusIntel Member
Member

Re: Power Query keeps case detail but Power BI loses case detail

@v-juanli-msft

Thanks for your reply.
You mention this functionality is by design.
What happens if the Power BI user/developer wants the case to be same in Power BI as it is in the source, and doesn't want Power BI to consolidate the case into a single string, how can this acheived?
Is there a setting to overule the Power BI consolidation?

 

It seems to be a bad design feature as the user may wish the case to be the same as the source for a reason. If it is a good design feature then can you give me an example of why it is good?

 

Thanks.

DanBusIntel Member
Member

Re: Power Query keeps case detail but Power BI loses case detail

I have found another post (see below link) that asks the same question as me on this topic.

https://community.powerbi.com/t5/Issues/Data-Modeling-Uppercase-and-Lowercase-issues/idi-p/280362

 

I've included the link here to so others may find an answer directly to my post , or through the other post via my link above.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 99 members 1,327 guests
Please welcome our newest community members: