Text data from Dynamics is uploading to Power BI as numbers. How can I import text?

[casunc]

Hello everyone,

When uploading data from Dynamics CRM (online) into Power BI, most columns with text are showing text as numbers. What can I do so Power BI loads the text for any columns that have text response options?

What I see in CRM

View in CRM

What I see in Excel spreadsheet downloaded from CRM

View in Excel 

What I see in Power BI. Notice how locality column (last one) shows up as text but not the others.

View in Power BI

Thank you in advance for your help! I truly appreciate it.

Carl

[v-juanli-msft]

Hi @casunc

Which version ofpower bi desktop do you use? please update to the lastese one.

Please note that when you turn on a feature in "preview feature", do close the desktop and reopen it so that this feature would be implemented.

what data type of these column? how about transform them as "Any" type?

Could you import the excel file to power bi and get the correct format?

Best Regards

maggie

[casunc · Accepted solution]

Hello Maggie,

I learned that the numbers correspond to the fields that use drop down option lists. I built a data model to connect these option lists to the corresponding text.

Thank you for your time,

Carl

[Baskar]

[casunc]

Hi @Baskar,

I tried this before posting with no success. I've updated my original post with examples of what I'm seeing. Please notice how the last column in Power BI is loading text but not the others.

Thank you for any ideas you may have to overcome this challenge.

Carl

[Baskar]

i agree that @casunc, 

As of my knowledge no other option to restrict auto detect column datatype.

Hope we have to change the datatype manually.

[affan]

Hi @casunc

Can you share some more details on this? Like which entity you are accessing and some screenshot of the dataset

Regards,

Affan

[casunc]

Hi @affan,

I've updated my original post. Thank you for any ideas you may have to address this challenge.

Carl