Is Real time Data Refresh possible with Odata Connection??

[gprasadsv]

Hi All,

Is there anyway to get the Real time data with Odata connection when a report is run in Power BI Service?

We have built simple row column reports with Power BI using Odata connection. What we see is that we can schedule data refresh at intervals during the day (8 times per day using PRO account). However, for User this is not sufficient and they would like to see the latest data without refreshing the data set manually when they run the report. Is there any way to achieve this in Power BI?

Thank you very much for your help and guidance here.

Best Regards,

Guru.

[Greg_Deckler]

@gprasadsv - I am not aware of Direct Query for ODATA.

[gprasadsv]

Thank you very much for your quick reply @Greg_Deckler .

I am sorry to ask these questions. I am not much knowledgeable on technicalities of Power BI. When you say there is no Direct Query for OData, is that the only possibility to get Real time data?

I saw some content on Power BI Website to use the data set mode as 'Push-data' or 'streaming data' to get Live content. Is there any possibilities with these? 

Thank you.

Best Regards,

Guru.

[Greg_Deckler · Accepted solution]

@gprasadsv - So, yes there are streaming datasets and such but if I understand correctly, you would have to write something to consume the OData and stream it out. I don't believe OData is steaming natively.

[gprasadsv]

Thank you for your inputs @Greg_Deckler.  It was very hepful.