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

[Santosh_25]

Hi All,

I have a data model and I am facing one issue like we cannot convert a value to type Record to type Table.
Below are the attached images of power query.

Any help is highly appreciable.

Thanks,

Santosh

[Santosh_25]

Hello,

I have connected to json file and source step is record. 

Basically my end result is like whenever the empty results showing that should not throw an error. 

Thanks,

Santosh.

[jennratten]

Here is how you can check to see if the value is a table and if not, convert it to a table.

Table.TransformColumns(Source, {{"Column1", each if Value.Is(_, type table) then _ else #table({"ExpandTableColumnName"}, {{_}}) }})

Same but for a record...

Table.TransformColumns(Source, {{“Column1”, each if Value.Is(_, type record) then _ else [a=_] }} )

https://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi... 

[jennratten]

Hello - is it valid that your source step is a record and not a table?  Do you need to debug that first or are you simply try to convert a record to a table?