real-time streaming with nested json

[Anonymous]

Hi!

I am tasked to make a dashboard that visualizes a real-time data stream. The data source uses a webhook to post to the Power BI API and with dummy data this works great. 

However, the actual data is nested json and Power BI doesn't manage to parse the data. 

Are there any workarounds to solve this? Alternatively, are there any tools that I could use to flatten the json between the source and Power BI.

Thanks!

-J-