Forum Discussion

JHob's avatar
JHob
Icon for Advocate I rankAdvocate I
6 years ago

Direct query connection to Mongo DB using ODBC

Hi   I would be grateful for some help.   I have a Gateway setup that allows me to connect to Mongo DB using ODBC.  I have setup a Power BI Dataflow to connect to the Datasource and connect to th...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

JHob , Is it listed under direct query source? If yes then you can.

 

Second, if you have configured in import mode, there many transformations which can do, which are not allowed in direct query mode.

 

refer :https://radacad.com/directquery-live-connection-or-import-data-tough-decision

https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

  • JHob's avatar
    JHob
    Icon for Advocate I rankAdvocate I
    6 years ago

    Thanks amitchandak

     

    If I cange the data connectivity mode to direct query I get the following message "This step results in a query that isnot supported in DirectQuery Model