cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jeppesal Regular Visitor
Regular Visitor

On-premises data gateway OData OAuth2

Hi,

 

I have some questions regarding the on-prem gateway.

 

  1. Is it correct than when you use the Gateway ALL of the models connections has to go through the gateway and if so, why?
  2. If question is true (which I believe it is) why is the connectors and authentication methods not 1:1 with the options i Power BI Desktop?
  3. When will you add OAuth2 to OData in the on-prem Gateway?

 

I have a big project (with some Project Online OData sources) and adding on-prem SQL Server as a source with the on-prem gateway caused me a lot of trouble and lot of work, because all my online sources had to go through the Gateway with limited authentication options 😞

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team dimazaid
Power BI Team

Re: On-premises data gateway OData OAuth2

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 

View solution in original post

15 REPLIES 15
Moderator v-yuezhe-msft
Moderator

Re: On-premises data gateway OData OAuth2

Hi @jeppesal,

Firstly, when you need to refresh your dataset in Power BI Service, you would need to add all the data sources contained in the dataset under the on-premises gateway. The on-premises data gateway acts as a bridge, which helps make the behind-the-scenes communication from a user in the cloud to your on-premises data source and back to the cloud quick and secure. For more details, please review this article.

Secondly, based on your description, you combine online data source and on-premises data source in a dataset and want to use on-premises gateway to refresh the dataset,right? On-premises gateway doesn't allow you to combine online data sources and on-premises data sources. This is a known issue that has been submitted in the following link and the feature that using on-premises gateway to work with online data sources is under review,  please vote it. And there is also an idea about adding OAuth2 method for some  online data sources, please vote it up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gatew...



Thirdly, to work around the issue in your scenario,  you can use the personal gateway to schedule refresh for your dataset


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jeppesal Regular Visitor
Regular Visitor

Re: On-premises data gateway OData OAuth2

Hi Lydia Zhang

 

I know what the purpose of the gateway is and that is way I find it strange that my online/cloud data sources must go through the gateway. Yes, the gateway support online sources (they are configured in the Manage Gateway site on Power BI Online). I guess that it doesn’t use the gateway as such but it is configure under the gateway online (yes I'm confused as well).


Again, why do I have to configure the online sources in “Manage my gateways” and second, why don’t online connectors in “Manage my gateways” have the same authentication options as online sources in Power BI Desktop (or personal gateway for that matter)?

 

Please work on separating online from on prem or at least make the connector consistent. I don’t think that consistency should be voted as a feature, it should be as such from the start.


Power BI is great but are missing some key elements before it is truly Enterprise Ready. It is not a valid solution to install a personal gateway on an Enterprise Server. Why is OAuth2 supported by the personal gateway and not by the Enterprise/on-prem? This doesn’t make sense and is sloppy work for Microsoft. Please fill in the gaps before you venture out in new exotic features.

 

BR

Jeppe Salmonsen

Moderator v-yuezhe-msft
Moderator

Re: On-premises data gateway OData OAuth2

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jeppesal Regular Visitor
Regular Visitor

Re: On-premises data gateway OData OAuth2

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).

Capture.JPG

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

Moderator v-yuezhe-msft
Moderator

Re: On-premises data gateway OData OAuth2

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





Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jeppesal Regular Visitor
Regular Visitor

Re: On-premises data gateway OData OAuth2

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

Moderator v-yuezhe-msft
Moderator

Re: On-premises data gateway OData OAuth2

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.
1.PNG

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Power BI Team dimazaid
Power BI Team

Re: On-premises data gateway OData OAuth2

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 

View solution in original post

Highlighted
jeppesal Regular Visitor
Regular Visitor

Re: On-premises data gateway OData OAuth2

Hi Dimah,

 

Thank you for your answer/comment.

 

I think mashup scenarios are very common and a feature where PBI shines (if the Gateway gap is fixed). For us consultants and PBI developers it’s the small gaps that causes frustration and makes implementation of PBI difficult.

 

In my case, I had a great project with some bye in from IT. Then the need for on-prem source came and I persuaded IT to create a VM and allow for Data Gateway. BUT the gap in features meant a long process of debugging, fixing (with the Personal Gateway) and new argumentation and approval for a second gateway (the name Personal isn’t the best for getting approved by IT).

 

I love PBI but you must focus on bridging the gaps and start thinking in real-life scenarios instead of what marketing wants. I don’t care about Apple-Watch support if my updates keep failing and I have to maneuver between the Desktop world and the Online world as two different worlds with different features.

 

Another topic is the collaboration part, again and again I find myself explaining how this works with multiple reports on the same dataset – yes you can create reports in Desktop (best experience) but only one etc. etc. I really hope the product team will rethink how the Desktop and Online PBI works together and bridge the gaps.

 

Regards

Jeppe

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors