Error cannot convert the value "SomeText" in type Record

[PowerBI88]

Hi, 

when I am importing the results from a REST API call I get the following message for some fields: Error cannot convert the value "ValueInTextualForm" in type Record.

Can you provide me some help on how to resolve this problem?

Thank you 

Kind Regards

Marta

[v-lionel-msft]

Hi @PowerBI88 ,

It may be the problem of this step, which Rest API are you using?

Best regards,
Lionel Chen

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

[negi007]

@PowerBI88 when you import data into powerquery window, it also does perform certain automatic steps. It automatically convert column into a data type basis value in first 1000 rows. Please check if there is any step where data is converted creating problem for you. You may try removing the steps in power query window as well.