Converting column ('Any' type) to 'Record' type

[MichaelHutchens]

Hi everyone,

I'm looking for the code to transfer a column to a 'Record' type. Its called 'Highlighted content filter':

Here's my code:

let
Source = SharePoint.Tables("https://<name>.sharepoint.com/sites/<sitename>/", [Implementation="2.0", ViewMode="All"]),
#"abd98fcd-44ed-4733-af92-635ad20f4001" = Source{[Id="abd98fcd-44ed-4733-af92-635ad20f4001"]}[Items]
in
#"abd98fcd-44ed-4733-af92-635ad20f4001"

I've seen from another post that the addition below might be what I need:

Text.FromBinary(Json.FromValue([ColumnName][Title]))

But I don't know how to add it to my code - any help would be appreciated 🙂

[v-sathmakuri]

Hi @MichaelHutchens ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-sathmakuri]

Hi @MichaelHutchens ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-aatheeque · Accepted solution]

Hi @MichaelHutchens ,
Thanks for reaching out to Microsoft Fabric Community Forum.

Actually, that's not a data type in PowerBI. When you create a merge query, the data appears in a structured format, allowing you to expand and select the columns you want to include in your dataset.

REFERENCE: Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Learn

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!

[MichaelHutchens]

Maybe I'm using the wrong terminology. The screenshot below is from another library on the same SharePoint site, and I'm able to open the 'Highlighted content filter' column and access its data, so I'm not sure why I can't do that in the case above:

[lbendlin]

Ah I see. In you first screenshot it is actually just a text string "Record"  rather than an actual record.  Objects are rendered in green to indicate you can look into them.

[lbendlin]

"Record"  is not a column type, it is an object.  You need to keep objects as "variant" ("Any" or ABC123)

You cannot hand records over to Power BI anyway.