Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Need urgent help, Power Bi changing text format capitalization from Power Query

Hi, I have a unique ID (text string) for each of my records.

 

My problem is that are said ID is considered unique based on the capitalization of the letters within the string.

The format appears correct within the Power Query Editor, however, once it's imported into Power Bi, the format changes.

 

IE:

Data loaded into Power Query Editor

Case NumberCase ID
ABC1235000g00001xVAW3
ZYX9875000g00001xVaw3
MNM6465000g00001xVB3b
NFB3055000g00001xVB3B

 

Data shown in PBI

Case NumberCase ID
ABC1235000g00001xVAW3
ZYX9875000g00001xVAW3
MNM6465000g00001xVB3b
NFB3055000g00001xVB3b

 

 

Any help is greatly appreciated!!

2 REPLIES 2
ChrisMendoza
Resident Rockstar
Resident Rockstar

@Anonymous -

 

Looks like this is known. https://community.powerbi.com/t5/Desktop/Case-sensitive-trouble-Power-Query-gt-DAX/td-p/414720 talks about it a bit then points to https://social.technet.microsoft.com/Forums/en-US/f12496b0-7424-44e7-a384-a08694595899/power-query-load-not-maintaining-case-sensitive-data?forum=powerquery.

 

Eventually you'll get to https://www.thebiccountant.com/2015/08/17/create-a-dimension-table-with-power-query-avoid-the-bug/

 

Hope that helps






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Anonymous
Not applicable

Thank you, I am still very new to Power Bi but it doesn't look like I am going to be able to do what I need to do.

 

I need the case sensitive ID within my data model (power bi) so I can create hyperlinks for reference to Salesforce webpages.

 

😞

 

 

Thank you

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.