Forum Discussion

jeppesal's avatar
jeppesal
Advocate 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,

I can understand your scenario, and your sceanrio has nothing to do with Pro or free account. You are not able to use On-premises gateway to refresh the dataset that contains on-premises data source and online data source. As mentioned in the  idea that I post, the feature that allow on-premises gateway to combine on-premises data source and online data source is under review, your patience is greatly appreciate.

Please use personal gateway to work around your issue currently.


Thanks,
Lydia Zhang





jeppesal's avatar
jeppesal
Advocate II
9 years ago

Hi Lydia,
I'm sorry if I sound grumpy, I’m just frustrated with the gaps in the core features that keeps me from implementing this great product at enterprise customers.


First, you said; “You are not able to use On-premises gateway to refresh the dataset that contains on-premises data source and online data source”.


I responded with a screenshot showing a screen shoot where I can create online sources in “manage gateway” – please explain that?


Second, if I go to this link https://powerbi.microsoft.com/en-us/documentation/powerbi-personal-gateway/ it clearly states that “The personal gateway is only available with Power BI Pro” – so explain why my issue has nothing to do with license when you say the work around is to use the Personal Gateway?

 

BR
Jeppe Salmonsen

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi jeppesal,

    When you combine on-premises data source and online data source in a single dataset, you are able to add the data sources under on-premises gateway, however, when you set refresh for the dataset, the "Use a data gateway" option will be disabled and it will fail when you refresh dataset. You need to use personal gateway in this sceanrio to make refresh work.


    In addition, I mean that your issue is caused by that on-premises gateway doesn't allow to combine on-premises data source and online data source in a single dataset, it is not caused by that you are using free account of Power BI.

    Moreover, as mentioned in this article, it also requires pro license when data from a dataset that connects to on-premises data using the On-premises Data Gateway.


    Thanks,
    Lydia Zhang