Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 .
@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.
@Anonymous Make a json where all of these are objects, then just uploading the data through json should do the work.
I am getting this data from excel spreadsheet in this format. How to make json from this data?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 66 | |
| 47 | |
| 43 | |
| 26 | |
| 19 |
| User | Count |
|---|---|
| 198 | |
| 126 | |
| 102 | |
| 67 | |
| 50 |