Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

help needed with power query transform

i have a excel spreadhseet with one of the column like in the screenshot below.  I tried to transform to JSON but its throwing error. How to expand those columns inside the brackets .file.png

3 REPLIES 3
ChiragGarg2512
Solution Sage
Solution Sage

@Anonymous , Use any excel to json online convertor. Caution that the excel that is provided only has the above column. 

OR

Replace every by and by }, and in the same way introduce commas between every key-value pair. Paste all of the values in [ ]  in notepad and save it as .json .

 

Also that no two values have , between them, i.e. notificationID and unreachableCount are not differentiated.

ChiragGarg2512
Solution Sage
Solution Sage

@Anonymous Make a json where all of these are objects, then just uploading the data through json should do the work.

Anonymous
Not applicable

I am getting this data from excel spreadsheet in this format. How to make json from this data?

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.