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.
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 !
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.