Real time Dashboard with ODATA source

[Anonymous]

Hello everyone,

I made this dashboard for my company and i'm trying to make it a real time dashboard. It gets ODATA type of data from project web service (PWA). I dont know if i'm on right way but i've downloaded the On-premises data gateway and config it, till there everything ok but when i try to config the gateway connection at PowerBI Online Service i can't config it properly because the connection required is ODATA with Organizational Account credentials type and none privacy level, but there isn't this option at PowerBI Online Service gateway clusters configuration.

This is how it's made the connection between the powerBI desktop and the ODATA database from PWAAnd those are the PowerBI options for Gateway clusters databases

 So, or i'm doing something wrong or that's not the way it's meant to be taken. Can anyone help me with this?
Thanks

[skaranth10]

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! 

[wlknsnBI]

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.

[skaranth10]

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.

[wlknsnBI]

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.

[skaranth10]

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

[GilbertQ · Accepted solution]

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