Reply

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

Hi everyone,

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

MichaelHutchens_0-1742919679683.png


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 🙂

1 ACCEPTED SOLUTION
v-aatheeque
Community Support
Community Support

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!


View solution in original post

6 REPLIES 6
v-sathmakuri
Community Support
Community Support

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
Community Support
Community Support

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
Community Support
Community Support

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!


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:

MichaelHutchens_0-1742939425885.png

 

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
Super User
Super User

"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.

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)