Connection mode

[DataVitalizer]

Hi Community,

Is there any technical explanation of what makes a datasource support either Import mode, Direct query or Live connection ?

Thank you in advance.

[Greg_Deckler]

@DataVitalizer - I may be incorrect, but I do not believe the limitation of import versus DirectQuery/Live is a limitation of the data source but rather the Power BI Connector. As evidence, there have been multiple cases where a Power BI Connector for a data source only supports import but later is extended to also support DirectQuery. That said, there are possibly specific things that a data source must support that enable DirectQuery.

[DataVitalizer]

Hi @Greg_Deckler,

Does that mean the suggested connection mode has nothing to do with the datasource itself but it's about the Powerbi connectors ?

[Greg_Deckler · Accepted solution]

@DataVitalizer - Yes, that is my understanding. The Power BI Connector written for a data source controls whether or not DirectQuery is supported or not supported, not the data source itself. Although, there may be some specific technical requirements that allows DirectQuery to be implemented on top of a data source. But, I mean DirectQuery is available on top of DB2 so...

[harshnathani]

Hi @DataVitalizer ,

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[DataVitalizer]

Hi @harshnathani,

Thank you for your reply, actually I know about that list but what I am looking for is what makes a datasource allow a specific mode of connection.

Thank you in advance