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

Sathya Sai Cheetirala 0 Reputation points
2024-05-08T13:13:15.2533333+00:00

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.

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,469 questions
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 27,972 Reputation points Microsoft Employee
    2024-05-08T14:58:04.1866667+00:00

    @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

    0 comments No comments