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.
Good afternoon all,
So I need help configuring a table referencing my API… I cannot get a list of elements to populate! I am receiving the following error:
"Expression.Error: We cannot convert a value of type Record to type Text.
Details:
Value=
379662=379662
396454=396454
396455=396455" ... etc etc
I believe I need to insert a List function (perhaps List.Distinct?), but I am not sure where to plug that into. I'm thinking perhaps part of Table.Transform. Anyhow, the API looks like this:
The function I am using looks like:
And the table:
Any help would be greatly appreciated!
Hi @jcawley
I found some blogs and I hope they could help you solve your problem.
Blog1: Expression.Error: We cannot convert a value of type Table to type List
Blog2: Expression.Error: We cannot convert a value of type Record to type Text - source is List of records
Blog3: Expression.Error: We cannot convert a value of type Record to type Text.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What happens if you hard code that product # (that looks like a date?) into the url and run that M code as a query instead of a function, so you can see which step causes the error? I am curious why you are using Record.ToTable, and suspect that is it. Typically with REST API JSON responses such a step (and the transpose step) is not needed.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |