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]]
      ]
    )
  )
)

     

Fabi66's avatar
Fabi66
Regular Visitor
3 years ago

Hi Jenn,

 

I removed the "Type64.From" in the "APIQuery" column definition.  But I still get the same error.  

 

 

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

    This is a Table.AddColumn function, so the highlighted portion of your script refers to the argument in the syntax that is looking for the column type, but instead of the type, such as type text, Int64.Type, etc, it is being fed a record.  You should replace this with 'type text'.

     

    Table.AddColumn(table as table, newColumnName as text, columnGenerator as function, optional columnType as nullable type) as table

       

    • Fabi66's avatar
      Fabi66
      Regular Visitor
      3 years ago

      I tried a couple of things but I guess I don't know how to do what you suggest.

       

      I need a column creating the Rest API call (APIQuery) which has to have header information.

       

      Then I'm using a second custom column to display the results of the API call 

      #" InvokeAPI" = Table.AddColumn(AddAPIQuery, "APIResponse", each Json.Document(Web.Contents([APIQuery]))  

       

      • jennratten's avatar
        jennratten
        Icon for Super User rankSuper User
        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]]
      ]
    )
  )
)