Power BI Ideas

How can we improve Power BI?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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

      83 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →

      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

    • Power Query functions in URL using a web data source under on-premise data gateway

      Add the ability to use Power Query functions in the source string not only for the PowerBI Desktop, but also to on-premise data gate
      Now It's not supported to type Power Query functions as web URL when we create a web data source under on-premise data gateway

      222 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

        8 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
      • Edit data sources in Enterprise Gateway

        I want to be able to edit server & database setup in the Enterprise Gateway. Currently, I can add new ones, but not edit ones already setup.

        74 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

          9 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
        • Personal Gateway Scheduling Enhancements

          The "Schedule Refresh" section of the Personal Gateway could be improved. Here are a few suggestions:

          1. "Schedule Refresh" only supports "Daily" and "Weekly". I would like for it to support "Every XXX Minutes", "Hourly", and "Monthly".

          2. Datasets do not support multiple schedules like a SQL Server agent job. You can basically define one schedule with up to 8 times. I would like more flexibility with scheduling.

          3. The maximum number of times you can specify is 8. I want the refresh the data once every hour, but with only 8 options, the most I can do with this…

          72 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

            5 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
          • Data Modelling when connecting to SSAS Tabular

            We need to be able to mashup data online with enterprise data in a SSAS cube. To do this, we'll need the data modelling feature accessible when connecting to SSAS Tabular.

            69 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

              5 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
            • Organizational Authentication for Enterprise Gateway

              Enable Organization Authentication in the Enterprise Gateway. Currently any pbix in which I call an on-premises data source and one in either CRM Online or Sharepoint Online cannot use this enterprise gateway. This is a very regular occurrence, since I support a lot of CRM Online instances. Instead I have to continue to "rely" on the very unreliable Personal Gateway running on my laptop.

              57 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

                8 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
              • Support for multiple instances of the On-premise data gateway on one server

                We host data and tabular models for multiple customers on one server. Each need their own tenant with different domains. This in turn requires us to have multiple servers just to host the on-premise data gateway.

                Would be great to be able to have multiple instances of the on-premise data gateway running on one server.

                This I imagine would also be useful for testing/preprod deployments in smaller setups where a dedicated server just for the gateway is overkill.

                55 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

                  8 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                • Move UPN mapping configuration to Enterprise Gateway level

                  Currently the UPN mapping configuration has to be set per data source.
                  Let's say you have: 2 SSAS data models, you make a data source for each data model and a group of 30 users who have access to both data models.
                  Then you are currently forced to duplicate the complete UPN mapping configuration for these 2 data sources in the gateway.
                  Correct administration of the duplicate UPN mapping configurations will be very difficult.

                  It would be better to make the UPN mapping configuration an Enterprise Gateway level configuration.

                  I thought about making it a tenant-wide configuration, which makes sense.…

                  45 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

                    8 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                  • Gateway Update Notification and Auto update for Enterprise Gateway

                    We should be notified when there is a new version of both gateways. In addition, the Enterprise gateway should be updated automatically (admins should be able to turn this on/off).

                    33 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

                      3 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                    • Add proxy configuration to Power BI ENterprise Gateway install routine

                      Instead of manually adding proxy server settings to the xml files, it should be possible to configure/enter proxy server settings when installing the Power BI Enterprise Gateway.
                      (..and please add idea category 'Infrastructure')

                      31 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

                        3 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                      • Consolidate Duplicate Datasources

                        Currently, a new data source is created within the Power BI service for every new Power BI report published through Power BI Desktop. A new data source is created even when the same data source from an existing report has already been created within the Power BI service.

                        This is most evident when you have created multiple Power BI reports from the same Enterprise Gateway (SSAS Tabular in my example) data source. We could have 5 different reports analysing data from the same model, which ends up being 5 duplicated data sources. This can end up in a mess when…

                        31 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

                          2 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                        • Load Balance Power BI Gateway

                          say I have many SSAS Tabular servers, each running the same SSAS tabular databases, then I use Azure AD and Azure load balance service to load balance these servers. Now from Power BI, I need a way to have a relationship of 1 Power BI gateway to many connections, one to each SSAS Tabular Server. this way, my users from the Power BI dashboard can have their queries load balanced (by policies set up by load balancer) and perhaps round robin across the connections - probably easiest to do.

                          23 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

                            1 comment  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                          • scheduled refresh Event Based

                            There needs to be a way to do event based scheduling instead of just specific time. For example, after a data warehouse has been updated. One way to implement this is to ability to trigger a refresh via an Web Service API call. This way companies can trigger the refresh via PowerShell or SSIS after the data warehouse has been loaded.

                            21 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

                              3 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                            • Failover is not available with the current Enterprise Gateway, this make it challenging when we want to use EntGW in scale. High Availabili

                              Failover is not available with the current Enterprise Gateway, this make it challenging when we want to use EntGW in scale. High Availability critical aspect for company whom want to adopt PBI as enterprise solution. Please consider.

                              21 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

                                0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                              • Add Incremental Updates to Enterprise Gateway

                                As a pro user,
                                I want the enterprise gateway to support increment updates
                                so that my yuge datasets be updated quickly and more efficiently.

                                20 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

                                  1 comment  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                • Route "Analyze in Excel" ODC through Power BI API & on-premises Gateway

                                  When clicking "Analyze in Excel" on a dataset connected to an on-premise data source with the gateway, the ODC file generated points directly to the datasource rather than routing through the Power BI API like the in-model dataset does. This is generally a local connection string that would not work for external users. Also, it effectively circumvents the user name mappings we have created on the gateway data source. Ideally there would be an option on the dataset to have the ODC file either point directly to the datasource or route through the Power BI API & Gateway.

                                  20 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

                                    2 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Microsoft Power BI does not support kerberos authentication while connecting Hadoop

                                    Hi ,

                                    BI Power not supporting Kerberos authentication to connect to Hadoop ,

                                    PLease enable this asap , we are checking for another BI tool as BI power don't have this connectivity setup.

                                    our Hadoop platoform is authincated by Kerberos.

                                    19 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

                                      0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Expose a PBI Gateway API for up/down monitoring

                                      Expose an API to retrieve Gateways and test the connections so we can proactively monitor Gateway health. This way we could know a problem exists before our consumers do.

                                      19 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

                                        0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Restrict who can create an Enterprise Gateway

                                        According to documentation, anyone in an organization can create an Enterprise Gateway. I suggest this should be a special permission so departments or individuals can't go around installing gateways without central approval from a Power BI admin.

                                        18 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

                                          4 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Excel Integration with Enterprise Gateway

                                          For excel data that is put in PowerBI Desktop as a source, and then published to Power BI, you currently need a personal gateway to refresh that, as Power BI recognizes it as coming from an on-premise source, which requires the use of a gateway to refresh. Can this be enable for enterprise gateway as well please? Since at the enterprise level you are most likely to use enterprise gateways rather than personal gateways

                                          18 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

                                            0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 6
                                          • Don't see your idea?

                                          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.