Forum Discussion

jeppesal's avatar
jeppesal
Icon for Advocate II rankAdvocate II
9 years ago
Solved

On-premises data gateway OData OAuth2

Hi,   I have some questions regarding the on-prem gateway.   Is it correct than when you use the Gateway ALL of the models connections has to go through the gateway and if so, why? If question ...
  • dimazaid's avatar
    dimazaid
    9 years ago

    hi jeppesal,

    Thanks for taking the time to walk thru the scenario and sorry to hear your frustration, hopefully we can get this resovled and get your dataset refreshing. 
    Few corrections to the statements made below:

    - Both the personal and enterprise gateway are PRO features and cannot be used with a free account. Are you seeing anything different? 

    - You can use the enterprise gateway to run your OData data source, but the limitation is the gateway doesn't support oAuth. So you will have to either use a different auth type, or seperate the 2 data sources into 2 datasets. 

    - The reason why the online data sources have to go thru the gateway is to keep your on-prem data secure, esp when you have mashup scenarios

     

    Finally we acknowledge the auth types gap between the PBI desktop and using it in the service and we're working on addressing them soon in later releases. 

     

    Thanks,
    Dimah 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi jeppesal，

Could you please tell us that if you combine online data source and on-premises data source in a dataset and want to use on-premises gateway to refresh the dataset? If so, it is not supported currently, please use personal gateway instead. Using personal gateway, you don’t need to add data sources under “Manage gateway”, and you just need to enter credential for your data sources, you will find “OAuth2” in the authentication method list.

Regarding to the issue that on-premises gateway doesn’t allow us combine online data source and on-premises data source and doesn’t support OAuth2 method for some online data sources, please vote the above ideas to help Power BI team prioritize this feature

 

Thanks,
Lydia Zhang

jeppesal's avatar
jeppesal
Icon for Advocate II rankAdvocate II
9 years ago

Hi Lydia

 

I had a model that has a Project Online OData source using OAuth2. The customer would like to add on-prem SQL Server data to that model. I installed the on-prem gateway and that worked fine for the new SQL source but now my OData source didnt work. It kept saying that it couldnt fint the source in the gateway. After some research I found that I had to add the online sources under "Manage gateway" - see screenshot (sorry it is in Danish).

This is way have the impression that on-prem supports online sources.

 

But you are telling me that if I whant to combine online sources with on prem I have to use personal gateway (a PRO feature)?

 

It seems very backwards that the enterprise oriented gateway is free at doesnt support online sources with OAuth2, but the PRO personal gateway does?

 

Again, in my mind this is not af nice-to-have feature, this is a need-to-have for a enterprise tool. A lot if IT departments are not very kean on installing user dependant gateways without any deasent administration.

 

BR

Jeppe