Forum Discussion
Helper IIconvert list/dict data in requird form
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 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
2 Replies
- amitchandak
Super User
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.
Paramjitamitchandak 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
