Combine enterprise gateway and online data sources
At this time, a gateway will not function properly if you are using data sources and one is online and one is on-prem. As soon as the online data source is added, the gateway is designed to gray out because Power BI interprets that it is no longer needed. I would like to be able to combine data sources from both on-prem and online sources together with the use of gateways.
We’ve started working on supporting oAuth based connections to go thru the gateways in Power BI which is the main blocker to why you can’t combine today. We’re starting with personal gateway, then will support the enterprise gateway (on-premsies data gateway) shortly after. Thank you for your continuous feedback and passion for this area. Stay tuned, we’re getting close!
The gateways team
efi goldman commented
Guys this one is so critical for my projects... Please prioritize!
Really really need this!! I created a data model using connectors available in Power BI Desktop and shared it in my workspace with others to test. Definitely disappointing when we moved to use the on premise gateway and it's not supported. Vote Smartsheet
Marcela Miranda commented
Do you have an uptade? I really need it.
Alex Garvin commented
Anthony Hipperson commented
Can we have an update please, the silence is almost more annoying than the lack of functionality.
I'll add my own concerns to the already long list... This is really blocking for large companies using PowerBI, please provide us with an ETA for this patch.
1) take away power bi free june 1 and make a lot of early adopoters look bad because the new model costs money and you notified all users at same time leaving devs no time to prepare plan b.
2) embolden those same early adopters to pitch the plan b that costs significantly more money...which means in many cases enterprises are looking at replacing legacy BI systems to find the cost savings for this cool new shiny bi system.
3) Fail because you weren't ready to offer big enterprises the type of connectivity they need for their on prem gateway to work. You have a lot of silly features enterprises will never use, but we can't sell that. You just needed to have this OPDG ready to go on june 1.... poc's for replacement are failing.
Do you need another use case? You take away power bi free sharing for O365 shops. So we need to get a 50k node. That's the same price as our Business Objects implementation but it will give everybody in the enterprise read-only access. You're looking good so far. The POC starts and stops with the fact this On Prem gateway can't refresh a data model (same as Bobj universes) with both sources. Tic Toc the POC will end and you don't get a deal. This has been hanging out there for quite a while.... fail.
This is a high priority issue for us as well. Looking forward to having it fixed asap. Thanks.
Any news about that? This has a huge impact on our solutions for our customers. In addition, using the personal gateway as a workaround is really painful. Will this be available soon?
Do you have any news please on the subject, one of our biggest customer is facing several issues due to that and it will be very nice to be able shortly to combine On-Premise and Cloud Datasource using the On-Premise Data Gateway.
Thanks a lot for your response and have a nice day
Rory Neary commented
Can we have an update please. It's affecting power bi premium.
John Nickell commented
I'll add a me-too to this list, and a request to know if this is closer to reality. While I do need the OAuth piece as well, even combining a connection that's on-prem and a anonymous web query (to get current time) cause the (Non-personal) Gateway feature to be disabled. The messaging around what is causing this is NOT clear. I was trying to debug my connection to the On-Prem resource only to find out a couple of hours later that it was just the fact that I had an 'online' resource included in my dataset that was turning off the gateway.
Do you have a timeline you can share for when you plan this to be available. This is quite a key feature we would like to have within Shell.
Kurt D commented
Any update ?
we are trying to Connect to on-premise data source, But we are having issues and error mentioned is: Data Source Can't be accessed by a data dateway. could you advise, Thanks.
Claudine Malzkorn commented
Any news? So urgently needed!
Any Updates on this yet?
Is there any news?
so no update in more than 3 months?