Forum Discussion
Helper IIconvert list/dict data in requird form
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
Super UserParamjit 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.
Helper IIamitchandak 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