- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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':
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 🙂
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
"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.

Helpful resources
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.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
15 | |
11 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
13 | |
9 | |
7 | |
6 |