Power BI Quick Tip: ​Visualizing Real-Time Cosmos DB Data Using Synapse Link​

[@Roy_Entertainer]

While connecting to cosmos db, there is a error in power bi saying "we couldn't authenticate with the credentials provided" tried to make changes in data source settings...still not working.

[@dataplatformcentral3036]

What kind of credential you're trying to pass? Account Key? or are you using synapse link?

[@Roy_Entertainer]

@dataplatformcentral3036 it's the primary key provided inside the cosmos db...am new to this platform not sure about synapse link

[@crsilvabz007]

And how about costs? What are your impressions? Thank you!

[@dataplatformcentral3036]

From costing perspective, it requires provisioning Azure Synapse in addition to your existing Power BI license And depending on how you want data to be processed/persisted you can opt for serverless (default) or your on dedicated sql pool. The former is pay per use mode and the latter like a provisioned hw based on reqd config

[@crsilvabz007]

Hello, thank you for your contribution. Is it possible to run what you've shown with Power BI Pro (or Embededd) or Premium is required? Tks

[@dataplatformcentral3036]

This feature is not really a Power BI feature. Synapse link is a seamless connectivity option provided within Cosmos DB for connecting to Azure Synapse workspace for close to real time access of container data through your Synapse workspace. It needs to be enabled at Azure Cosmos DB end. As far as Power BI is concerned all it require is to use the standard Synapse connector to connect to your Synapse instance. It doesnt require any Premium license for this.

[@callummatthews7587]

Thank you for this. Just (almost) what I was looking for. I have a couple of questions: 1) if I publish this to Power BI service, would it update real-time, as in almost instantaneous? 2) I initially was thinking of using streaming dataset where I send POST requests to the API url of the streaming dataset, then create a report based on that dataset and finally a dashboard. But if I want to see live data instantly, I am restricted to the 5 visuals in the live tiles of the dashboard. Do you any workaround where I can have a map update in near-time in a dashboard? Thanks.

[@dataplatformcentral3036]

Yes. It will update close to real-time by virtue of the Synapse link feature which will add an analytical store to Cosmos DB container and expose it through Synapse Analytics into Power BI through the direct query connection. Sorry didn't understand the second part. What do you mean by map update? Do you map visual?

[@callummatthews7587]

@@dataplatformcentral3036 Thank you for the reply. Yes, I meant I wanted a map visual to update in real-time in a dashboard. But we're restricted to a few visuals if we use the live tiles features. Any idea of how to have a map visual update in real-time, without using Synapse?

[@dataplatformcentral3036]

I havent tried it myself, but may be Event hub + Stream Analytics might help you out on this

[@ateekain5739]

Can Synapse simultaneuosly connect to two azure cosmos DB at a time and query them together.

[@dataplatformcentral3036]

Yes Using Synapse link for CosmosDB its possible

[@srikantht8583]

I want video on log analytics to power bi on alerts based

[@dataplatformcentral3036]

If you mean linking Power BI to Log Analytics and analyzing usage etc. that video link is given below kzbin.info/www/bejne/fmikhIuZoKiriNk

[@ateekain5739]

Can Synapse or POWER BI simultaneuosly connect to two azure cosmos DB at a time and query them together.

[@dataplatformcentral3036]

Same answer as before