Forum Discussion

StijnJanssen's avatar
StijnJanssen
Regular Visitor
9 years ago
Solved

power BI gateway connection issues

Dear all,    Within Power BI Desktop we are making a connection with a SQL database and can choose for a import or directquery connection. Without a personal gateway I can get realtime data in the...
Gateways
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    StijnJanssen

     

    If you want to use DirectQuery, all tables must come from a single database. So if you want to add a second datasource, you need to swith to Import mode.

     

    For the reason to use personal gateway, it is just like you mentioned above. Currently, on-premise data gateway doesn't support OAuth2 based authentication. We are not able to add the online data sources in data gateway as well as on-premise data sources, so that we can't configure this kind of combined dataset to use data gateway. The workaround is to use on-premise data gateway (personal mode).
     
    PG have started working on the data gateway and ETA is end of August. See: Combine enterprise gateway and online data sources.

     

     

    Best Regards,
    Herbert

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

StijnJanssen

 

Yes, we just need to wait for the new version according to the reply from product team.

 

Best Regards,
Herbert