Can Odata as Datasource, can give us LIve Connection

[ukantkumar]

Hi,

I am consuming OData feed as a Datasource in my power bi report.

So my concern is, Can I get a live connection, I mean no need to refresh the Dataset.

(My database is MongoDB and it is in cloud instance)

warm regard

Utpal

[Anonymous · Accepted solution]

Hi @ukantkumar ,

Nope, live connection only works on specific datasource, I think it is impossible to enable on odata feed connector.

For your requirement, I'd recommend you to refer to following links to create a custom connector to enable 'direct query' mode on odata feed, it will refresh when you interact with visual data:

Enabling direct query for a data source via an odbc driver

M Extensions

Regards,

Xiaoxin Sheng