Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (17.6k points)

when retrieving data from a web-based API into the Power BI, I did end up with a quoted record (text type) which I am unable to convert to a record. There must be a simple way to do this, unfortunately, I was not able to find it.

So simply record=[A=1, B=2]  is implicitly detected, if written like this record = "[A=1, B=2]" you end up with a text, which needs to be converted. What function can do this kind of conversion?

This is the result similar to the API, which will require transformation on the entire column.


    Source = {"[A=1, B=1, C=0, D=1]","[A=1, B=1, C=0, D=1]"},

    Table = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)



1 Answer

0 votes
by (47.2k points)

Evaluate the expression:


    Source = {"[A=1, B=1, C=0, D=1]","[A=1, B=1, C=0, D=1]"},

    Table = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

    Evaluate = Table.AddColumn(Table, "Custom", each Expression.Evaluate([Column1]))



Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers


94.1k users

Browse Categories