Forum Discussion
Real time Dashboard with ODATA source
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
- 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
6 Replies
- GilbertQSuper UserHi 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 - skaranth10Helper I
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!
- wlknsnBIHelper II
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.
- skaranth10Helper I
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.