How to build Visualization charts for complex Json data stored in Azure Cosmos DB

Question

Hi,

We have a use case to build Visualization Dashboard(charts) on top of complex Json data stored in Azure Cosmos DB.

we tried with different approaches

1)we have done some research regarding MongoDB Atlas which has inbuilt feature to develop charts but data should be stored in Atlas DB in our case data is stored in Azure cosmos DB this will not fit our solution.

2)we tried for Power BI but our json data has multi level complex json string its difficult to flatten the data and build the charts in powerBI

3)Elastic serach + Kibana but data should be stored in elastic search to build the charts in Kibana

As we need to use only Azure services to store the data ,as per client policy we can not migrate data to other data sources.Can some one suggest the best approach to build the visualization dashboard on top complex json data stored in Azure cosmos DB.

Answer 1

@Sathya Sai Cheetirala Welcome to Microsoft Q&A thanks for posting your question.

If it is urgent, then you can check Synapse Link is GA and you can build PBI dashboards using Synapse SQL Serverless.

If you can wait, Fabric Mirroring is in Preview, GA date not defined yet, and you can build PBI dashboards using direct import or SQL Analytics endpoints.

Both SQL engine options have OPENJSON and CROSS APPLY functions, that can help to query JSON nested data.

 

Regards

Geetha

Answer 2

Hi Geetha,

Yes we are exploring Azure Synapse analytics and doing POC to validate the results.

thanks for your inputs.