cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tmayank1159 Frequent Visitor
Frequent Visitor

Transform Alpha numeric GUID to string values

Hi,

 

I have imported data from CRM into PowerBI and some values in some fields (columns) are appearing in alphanumeric format which is not what i want.

power.PNG

What could be the problem and how can I resolve. The above picture shows what i mean. Intead of hospital names i am getting these alphanumeric values. 

Help at the earliest will be appreciated a lot as my project is stuck because of this! Thanks a ton in advance !

3 REPLIES 3
Moderator v-sihou-msft
Moderator

Re: Transform Alpha numeric GUID to string values

@tmayank1159

 

What's the data type in your data source? How did you connect the data source? Please try to connect via Odata.

 

As you said your data is from CRM, your data might be encrypt already so that you can only get the Alpha numeric. In Power BI Desktop, either Power Query or DAX has no function to decrypt this code. 

 

Regards,

tmayank1159 Frequent Visitor
Frequent Visitor

Re: Transform Alpha numeric GUID to string values

The data type is string only, and it is appearing alright in CRM. We have tried to import data via an api. Many field are in the correct format except these. 

 

K_Zarar Frequent Visitor
Frequent Visitor

Re: Transform Alpha numeric GUID to string values

Hi there,

 

Did you find a solution or a workaround to connecting to CRM?

 

I've ran into the same problem as well.