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.
Will finish the rest soon
I agree this is hurting adoption of Power BI within our company as well. We have not yet promoted use or licenses beyond a test group. Multiple data sources are common in our reports.
Heber Olimpio commented
Alguma novidade em relação a isso?
Anton Rozenson commented
April gateway update had nothing to add ... disappointing - the promise date on this was Christmas 2017. Any expectations from Microsoft?
I'm trying to connect SharePoint online datasets (OAuth) and a JIRA API (gateway). This is a big problem within my org, and fixing this would enable Power BI to be used more widely. With this current restriction, we have limited use cases for Power BI.
Still not functioning. Indeed using a merge queries between an on prem and online Datasource will cause the gateway not working.
Makes powerbi pretty useless for us
Same comment as everyone - I would LOVE to get an update on this. Not only does it consume ridiculous amounts of time to do manual updates, it is hurting adoption of Power BI. Let's get this done!
Also, If anyone out there is confused about what can be done at this point, maybe this will help. I can perform scheduled refreshes using both on-prem and online (Sharepoint, in this case) data by ensuring I do NOT combine the two sources in M/Power Query Editor. If I do try to combine in M, the 'gateway connection' doesn't allow for scheduled refreshes. So, bring both sources in via M but don't combine them using a 'merge queries' or an 'append queries'. Instead, combine them using DAX after the import of data; use LOOKUPVALUE() or something. After that, publish and go to 'scheduled refresh' in the Power BI Service. In the 'data source credentials' section, use OAuth2 credentials for 'web'. It works for me so I really hope this helps somebody out there. It drove me nuts for a long time.
Mudassar Riaz commented
Has there been any progress, or ETA on this. Have a real ETA can at least allow people to plan things accordingly.
What is the current status on this? The last news dated from Nov, almost 5 months ago?
How far off is this update from happening?
Microsoft Power Bi unfortunately still a beta product. and go figure this is an outstanding issue 2 years after it was announced they'd look into it.
Please make this your number one priority. It's an unacceptable limitation not being able to mix online and on-premise sources. I'm quite flabbergasted this is still an issue.
Ismael Umpierrez commented
I'm so confused about what works and what doesn't work yet with this. I have one report that works, the other one doesn't work with the gateway.
Christiaan B. commented
When will we be able to use full mashup capability (planned for late 2017)?
Can you please provide an estimated delivery date?
Steven Tran commented
Any update on this please?
Chris Hawkins commented
Really need an update on this!
Gustav Palsson commented
Soon (TM) since nov 2017.
This is a major problem.
Jesper Barslund commented
To confirm, will the recent gateway update enable me to combine data from on-prem SQL and online Google Analytics data (OAuth2 login)
Unbelievable that this is still not working yet. I think it is a major requirement to combine on-premises datasources and online datasources using an enterprise gateway.