Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
praveenk
Frequent Visitor

Expression.Error: We cannot convert a value of type Record to type Text.

Hello,

 

I am passing the below query and getting an error message in the response saying "Expression.Error: We cannot convert a value of type Record to type Text."

 

There are 3 mandatory parameters in the body, of which category id is an integer and the other two are string data types. Any suggestions would be appreciated to fix the error.

 

let
url = "https://api.xxxxxx/report",
headers = [#"Content-Type" = "application/x-www-form-urlencoded",
#"Accept" = "application/json",
#"Authorization"="Basic Token"
],
body = [categoryId = 1, employeeId = "radmin", reportName = "Activity"],
response = Json.Document(Web.Contents(url, [Headers = headers, Content = Text.ToBinary(body)]))
in response

 

Error Message:

Expression.Error: We cannot convert a value of type Record to type Text.
Details:
Value=
categoryId=1
employeeId=radmin
reportName=Activity
Type=[Type

 

Thanks

1 REPLY 1
lbendlin
Super User
Super User

body is a record, not a text.

 

Please follow the documentation. Use Json.FromValue. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-2

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.