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.

1,333 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Rflad shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    219 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Daniel Davis commented  ·   ·  Flag as inappropriate

        Has anyone found any workaround for this? It is crippling my ability to publish our latest dataset since migrating to using CSV files in Sharepoint to filter and augment database results

      • David Cresp commented  ·   ·  Flag as inappropriate

        I have just come up against this problem. One year on from starting it still seems to be a major issue. Please fix this one MS.

      • Melissa Coates commented  ·   ·  Flag as inappropriate

        In the settings for the On-Premises Data Gateway, there's an option to “Allow user’s cloud data sources to refresh through this gateway cluster.” You can see that option shown on the 2nd screenshot on this page: https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud. Hopefully that option will help some of the people still commenting on this being an issue.

      • Charles commented  ·   ·  Flag as inappropriate

        I've been struggling with this issue for the last two days. One source is SQL on-prem using an enterprise data gateway, other source is an Excel file hosted on Sharepoint online. Use either one by itself, it works as it should. If you try to use the two data sources together, Power BI service breaks down and gets confused as to what to do and how to authenticate.

        Very surprised at this limitation, seems like it should be a basic functional requirement.

      • Anonymous commented  ·   ·  Flag as inappropriate

        What is the status of this "Combine enterprise gateway and online data sources"?

      • Anonymous commented  ·   ·  Flag as inappropriate

        My dataset has Salesforce as its only data source. It says I don't need a gateway but that I can use one for enhanced control. When I tried selecting my enterprise gateway, I get the error message "Salesforce{"loginServer":"https://login.salesforce.com/","classInfo":"report-detail"} Cannot be added to gateway". Why? If I don't use a gateway, I am able to do Refresh Now.

      • maRK commented  ·   ·  Flag as inappropriate

        Please let me clarify this issue, because some people are saying that it has been fixed - IT HAS NOT.
        Yes- you can mix sources from Web based ( sharepoint etc) AND Sqlserver .... SO LONG AS THEY ARE ISOLATERD in your PBIX file . However once you append or merge those 2 sources, then the gateway will disappear. That is the bug, and in my opinion a very serious bug because the chances are , if you have more than one data source, you almost certainly want to combine them!
        Come on MS - how much longer do we have to wait ... 'will finish soon' in Nov 2017???

      • Rayno commented  ·   ·  Flag as inappropriate

        In general with regards to connecting to the exchange online mailbox hasn't been smooth in the cloud services. The desktop refresh works but once uploaded it either works for while then breaks, leave it for a few weeks then it works. Been through this cycle 3 - 5 times. I was supper excited that it started working again a couple of days ago "Yes no more manually uploads" . Due to it working I started merging on premise data with the exchange online contents hence we here. I tried to use the personal gateway with no success and I'm back in the cycle, here is the error "Underlying error code: -2147467259 Table: Mail.
        Underlying error message: ErrorItemNotFound: The specified object was not found in the store., The process failed to get the correct properties." This error was in the cycle that I mentioned. Support team you got it right on the enterprise gateway, just needs to be addressed on the personal gateway. Still hope but back to manual uploads.

      • Rayno commented  ·   ·  Flag as inappropriate

        Hi, I'm in the same basket with regards to this particular problem. Has there been any progress or updates on the problem? Spent 2 days on a report, now I just feel silly . . . Shall temp the personal gateway (installed on the same server as the enterprise gateway)

      • [Deleted User] commented  ·   ·  Flag as inappropriate

        This has been fixed? According to some comments? - or so it seems. Big thanks to MS for updating this thread that it has been completed (if it actually is). Come. On. Guys... Ugh.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Is there any update on the target timeline for full functionality (being able to refresh these combined data sources and also merge them)?

      • Rflad commented  ·   ·  Flag as inappropriate

        It does not support merge/append, but I guess it supports creating relations between the sources?

      ← Previous 1 3 4 5 10 11

      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.