convert list/dict data in requird form

[Paramjit]

Hi Team,

API is returning data in list/dict format and i am saving that in csv.

anyone idea to hanlde this data in power bi. attached is sample data and required format.

Thank you,

Paramjit

[amitchandak]

@Paramjit CHeck is detected as JSON, if not on the right click of column, in power query you have an option

Convert to json and expand

If this does not help

How to import JSON Data: https://youtu.be/MPYfEetvFH4
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Paramjit · Accepted solution]

@amitchandak  thank you. i was able to format the data using Power BI query editor > transform > json . 

it was giving issue with single quotes . i had to replace the single quotes with double quotes.

Thank you,

Paramjit