Create real time dashboard in POWER BI using data present in AZURE COSMOS DB

[khush19]

I am new to AZURE and I have a task to create real time dashboard in POWER BI using data present in AZURE COSMOS DB

I need to research first and then finilize the resource I need in AZURE to do it.

I came across below approach:

1. azure-cosmosdb-spark connector which allows you to use Apache Spark as the bridge between Power BI and Azure
2. Cosmos DB- Azure Function-Event Hub-Stream Analytics-Power BI

which one is best approach?

Thanks

[v-eachen-msft · Accepted solution]

Hi @khush19 ,

In other cases, most of them use connector(approach 1). I tend to use this method to make it easier to find a solution even if something goes wrong.

[khush19]

Is the connector aproach is good when we are using big data?

Or both the approach are same?

Apart from the approach I found ,is there any other ways also to load the real time data in POWERBI through COSMOS DB?