Error message when import text instead of number

[Cheryl_Woo]

Hi all,

I tried to import text instead of number by changing the Data Type to be "text"

GID --> Original : 9991;  New: 9991A

Looking forward to your advice. Many hanks 🙂

[v-yanjiang-msft]

Hi @Cheryl_Woo ,

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft]

Hi @Cheryl_Woo ,

The first error message indicates you want to convert the column to Number type, not text as you said. Please see the Applied step which cause the error and check if you convert the text type to number type.

For the second error, delete the relationship first and apply changes then create relationship again.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Cheryl_Woo , In your data model, you have a dimension table( on one side in 1-Many relationship). In that one side table, you are getting a blank value. That is not allowed.  Filter out null values in power query