Forum Discussion

Fabi66's avatar
Fabi66
Regular Visitor
3 years ago
Solved

Power BI Expression.Error: We cannot convert a value of type Record to type Type. Details: Value=[Re

I get this error in Power BI: Expression.Error: We cannot convert a value of type Record to type Type. Details:     Value=[Record]     Type=[Type] When I try to use an existing column to query...
Need Help
  • jennratten's avatar
    jennratten
    3 years ago

    You could do it like this:

     

      _BaseUri = "https://my.website.com/rest/api/candidates",
  //_RelativeUrl = ,
  #"InvokeAPI" = Table.AddColumn(#"Removed Columns", "Results", each Json.Document(
    Web.Contents(
      _BaseUri, [
        //RelativePath = _RelativeUrl,
        Headers=["Bearer xxxMyTokenxxx", #"Content-Type"="application/json"],
        Query=[CandidateId=[CandidateId]]
      ]
    )
  )
)

     

jennratten's avatar
jennratten
Icon for Super User rankSuper User
3 years ago

Hello - it looks like you have already converted your CompanyId to Int64.Type in the #"Changed Type" step so I don't think there would be a need to include an additional accommodation for type in the #"AddAPIQuery" step.  When you see the error you should see a 'Go to Error' button.  This should take you to the step containing the error and also show the actual error record.  Can you please try that and then post screen shots of what you see?  Thanks!