Forum Discussion
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
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
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
Thanks, Jeppe for the great feedback.
As I mentioned we're working on bridging these gaps between PBI Desktop and PBI service. We appreciate your commitment to using Power BI and looking forward to getting you to a seemless experience with both collaberation and refresh.Thanks!
DimahWhat is the work around until this issue is fixed?
I'm connecting to a Dynamics 365 datasource (only OAUTH as far as I know) and some on premise ODATA sources.
I can't figure out how to get this working in the mean time.
The fix is to install both gateways and add/configure the on-prem sources in "manage gateways" inpower bi online.
