How can we improve Power BI?

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.

660 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RfladRflad shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  Dimah ZaidalkilaniAdminDimah Zaidalkilani (Admin, Microsoft Power BI) responded  · 

    Hello everyone,

    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!

    Thanks!
    Dimah
    The gateways team

    83 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        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

      • Anonymous commented  ·   ·  Flag as inappropriate

        Hi everyone,

        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.

        thx

      • MattMatt commented  ·   ·  Flag as inappropriate

        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.

      • MattMatt commented  ·   ·  Flag as inappropriate

        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.

      • AlexAlex commented  ·   ·  Flag as inappropriate

        This is a high priority issue for us as well. Looking forward to having it fixed asap. Thanks.

      • BenBen commented  ·   ·  Flag as inappropriate

        Hi Dimah,

        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?

      • YounesYounes commented  ·   ·  Flag as inappropriate

        Hello Dimah,
        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

      • John NickellJohn Nickell commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Dimah,
        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Hello Dimah,

        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.

      ← Previous 1 3 4 5

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.