The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Expression.Error: Incompatible Types - Unable to convert Binary to Record. The provided value [Binary] cannot be transformed into the expected type [Type].
My code is:
---------------------------------
let
Credentials = "Username:Password",
AuthKey = "Basic " & Binary.ToText(Text.ToBinary(Credentials), BinaryEncoding.Base64),
url = "https://xxxxxxxxxxxxxxxxxxxxx.io/api/v1/product_bundle_index",
headers = [
#"Authorization"=AuthKey,
#"Content-Type" = "application/x-www-form-urlencoded",
#"Accept" = "application/json"
],
//postData = "{""order_id"":""[11931]""}",
record = [order_id = "11931"],
postData = Json.FromValue(record),
response = Json.Document(Web.Contents(url, postData))
in
// jsonResponse
response
Could you try this steps?
I am trying to fetch the data using POST API. Whenever try to retrive the the data from query it is giving me an error "Expression Error: We cannot convert a value of type Binary to type Record"
User | Count |
---|---|
57 | |
54 | |
53 | |
47 | |
31 |
User | Count |
---|---|
175 | |
88 | |
69 | |
48 | |
47 |