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.

922 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

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

    174 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...
      • Jean-Pierre Riehl commented  ·   ·  Flag as inappropriate

        Just to add my results to those provided by Helge :

        Note working : SharePoint Folder (excel file) and MySQL On-Premises (into separated queries)

      • Jo-Anne commented  ·   ·  Flag as inappropriate

        Is this going to include a fix to merging different sources, both on prem, and that causing the gateway to be unavailable?

      • Helge commented  ·   ·  Flag as inappropriate

        We tested the new version of the Enterprise Gateway and the improvements. Please find below our results:

        Working:
        - Create a dataset with a mixture of cloud and on prem data sources, e.g. SharePoint Online and SQL on Prem

        Not Working (Enterprise Gateway is greyed out):
        - A combination of cloud and on prem data sources in a query, e.g. Source = Table.Combine({OnPremQueryResult, CloudQueryResult})

        Sidenote
        - A dataset which uses the Azure Consumptions Insights connector in combination with any on Prem Datasource, even if there is no combination among theses queries (this works if you do not use the Azure Consumptions Insights connector).

        Thank you for fixing the combination issue as soon as possible.

      • Anonymous commented  ·   ·  Flag as inappropriate

        I have experienced the same thing as Mike Honey in the oil and gas industry. Our users were very excited to be able to use the Enterprise Gateway for combining on-prem and cloud sources but then without data-mashup they said what is the point. I hope you guys continue to make progress in this regard since we have 100's of users who are still waiting.

      • Mike Honey commented  ·   ·  Flag as inappropriate

        It looks like this has missed the November release, ref https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-november-update-is-now-available/

        It's frustrating as there was lot's of other functionality added, which all seems edge/niche use cases. I estimate this mashup issue trips up and frustrates hundreds of users every day - they build something that seems fine in PBI Desktop, then can't use the gateway to refresh.

      • Lazar commented  ·   ·  Flag as inappropriate

        It is possible to combine data sources from both online sources and on-prem using on-premises data gateway (personal mode). I have never tried enterprise solution but in my opinion doesn't make sense if enterprise version can't complete what on-premises data gateway (personal mode) can.

      • Josep commented  ·   ·  Flag as inappropriate

        What is phase 1 and how many phases are still to do? How can be this topic marked as completed?

      • Nikhila Gudipati commented  ·   ·  Flag as inappropriate

        Does anybody know what is contained in Phase 1 & how I can get more information regarding the subsequent phases?

      • Karl Larsson commented  ·   ·  Flag as inappropriate

        I’m a little confused. Are we now able to combine online and on premises data in a server gateway and join the two?

      • Mo El-Rous commented  ·   ·  Flag as inappropriate

        This shouldn't be marked as completed! It should be marked up as completed only when all phases ended!

        Phase 1 didn't even fix the main topic, So please re-open this so we could at least increase the vote number as this is a very important feature that PowerBI MUST have.

      • Nick commented  ·   ·  Flag as inappropriate

        Why is this marked as completed? It does not fix the original idea that was posted.

      • Anonymous commented  ·   ·  Flag as inappropriate

        I didn't can switch the personal to the enterprise. Now it is enabled, but when you try to refresh, it is not working.

      • Anonymous commented  ·   ·  Flag as inappropriate

        We are most interested in being able to 'mash up' these data sources. Please prioritize this feature. It seems premature to mark it completed, when it is not fully functional.

      • roel matthys commented  ·   ·  Flag as inappropriate

        I agree with cbailliss. Closing this item while providing absolut no or limited info is not the way to communicate to customers who are willing to provide feedback.

      ← Previous 1 3 4 5 8 9

      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.