Forum Discussion

MichaelHutchens's avatar
MichaelHutchens
Helper V
1 year ago
Solved

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://<na...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    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's avatar
MichaelHutchens
Helper V
1 year ago

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's avatar
lbendlin
Super User
1 year ago

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.