Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

how to have near-real-live data in Power BI report via Azure Cosmos DB

Hey everybody,

I know I can use URL to pass into power bi and import the json data and view data in power bi, but users want to see near-live-data
example : one record is updated and they want to see this change (with a trigger in azure i dont know) within 30seconds to 1 minute.

please let me know what is the possibility of real time refreshing the data from cosmos DB to Power BI


thanks !

2 REPLIES 2
Anonymous
Not applicable

@DanielGarcia 

and do you have any example or idea how fast it is ? 
only example I found is 2500 records and refresh time within a minute but we have millions of records.

please let me know if you have any experience/idea on it.

thanks

DanielGarcia
Advocate I
Advocate I

Good Night, man

 

Yes, you can make this with the DirectQuery and Azure Cosmos.

 

Try this:

https://learn.microsoft.com/en-us/azure/cosmos-db/integrated-power-bi-synapse-link

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.