Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
@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.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |