Forum Discussion

FabvE's avatar
FabvE
Brass Contributor
Nov 27, 2024
Solved

Power Query: convert table type column to JSON string

Hi, I have generated a query in PQ with aggregates a column of mail adresses to the unique mails. Now the other columns are put together in one single column of type "table": When clicking on s...
BI & Data Analysis
excel
power bi
  • Lorenzo's avatar
    Lorenzo
    Nov 28, 2024

    Hi

     

    Add a Custom Column with:

    =Text.FromBinary( Json.FromValue( [PQ_Final output] ) )

    See the example on the https://learn.microsoft.com/en-us/powerquery-m/json-fromvalue

Lorenzo's avatar
Lorenzo
Silver Contributor
Nov 28, 2024

Hi

 

Add a Custom Column with:

=Text.FromBinary( Json.FromValue( [PQ_Final output] ) )

See the example on the https://learn.microsoft.com/en-us/powerquery-m/json-fromvalue

Resources