Forum Discussion

ukantkumar's avatar
ukantkumar
Helper I
7 years ago
Solved

Can Odata as Datasource, can give us LIve Connection

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's avatar
    Anonymous
    7 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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