Forum Discussion

jct999's avatar
jct999
Advocate II
3 years ago

Power Query converts case during import when it is not asked to do so

Hello   I have an Excel file on a Sharepoint that contains sentences, and I import these data in a PBi dashboard. Problem : During import, it converts letters between uppercase and lowercase, wh...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi jct999 

 

I'm afraid this behavior cannot be avoided currently. In Power BI Desktop, strings are case insensitive. It will take the case of the first sentence then convert the next similar sentences with this case, just like that you have found. This is by design. I think its purpose is to reduce the storage size of column data in the model. 

 

Do you must have upper and lower cases of similar sentences at the same time? If not, you can use Power Query Editor to convert the column to upper case or lower case in advance, then load the data into Power BI Desktop. In this way, sentences in the column will have consistent case. 

 

Open Power Query Editor through Home > Transform data, then transform the COUNTRY column to lowercase or uppercase. After that, click Close & Apply under Home tab to reload data into Power BI Desktop. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.