Forum Discussion
Real time Dashboard with ODATA source
- Hi there
If you are creating a real time dashboard, you will need to push the data into the Power BI Service.
Here are more details if this is what you are trying to achieve.
https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming
Hi,
Were you able to setup your realtime dashboard with Odata? If yes, I would like some help, please.
I am trying to setup a realtime streaming dashboard as well, but am not sure how to go about it.
I have done the initial steps - setting up a Streaming Dataset on my Power BI service and setting up tiles. But I am not sure how to proceed to connect this to my Odata feed. Any help would be appreciated!
You can't with odata. I believe project web is also build on CDS so you could do direct query (preview feature) which is real time.
I see.
Thank you for letting me know.
If anybody has found a way to work around this using Odata, please do let me know!
I appreciate your help guys.
Thank you.
It's not about a workaround.
Look, odata is a query. It will give you the data when you ask for it. You can have PowerBI ask for it using the scheduled refresh but you are limited to 8 refreshes a day (everything but real time) if you have pro. If you have premium, you can go to pretty much unlimited now using power automate, but still it's not exactly realtime because the power automate takes between 5 & 30 secs and then the refresh itself of the source which can be anywhere between 10 secs till ....
Bottom line: you can't with odata because you need to keep querying to get the data which results in delays & limitations. It can't push data either.
Thank you for explaining it further. This makes it clearer to me.
I have setup scheduled refreshes already. I guess I will have to make do with a refresh every 3 hours for the time being.
Thank you once again!
Regards