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. Contributor user access level on enterprise gateway

    I think having just two levels of user for the gateway is a bit limiting to the idea of citizen developers.

    Currently my company, and I imagine most companies, IT is in charge of administering the gateway as it sits on one of their servers.

    This means only IT has the ability to add connections and add people onto them. It would be great if they could assign users as a "contributor" type role where they can setup connections and add users to their connections, but they can't access any of the gateway configuration.

    1 vote
    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

      0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
    • Implement Live/DirectQuery for Postgres

      Currently only scheduled refreshes are possible.

      Please enable DirectQuery for Postgres in Enterprise and Personal Gateways so we can leverage Postgres db's running on Azure.

      Thank you.

      94 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

        3 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
      • support direct query excel

        It wouldb be great to support online excel data source in direct query mode.

        4 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

          0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
        • Let "try" and "try otherwise" the Gateway offline situation

          It seems, that currently it is not possible to "try" the situation when Gateway is offline. Now, in case Gateway is offline and I have R.Execute call, PBI service just completely stops refreshment, even if just part of data is gotten from the R script from Gateway.

          It would be great to let a user decide in M code what to do in case there are some troubles with Gateway access, obviously through using "try".

          1 vote
          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

            0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
          • Allow multiple credentials for the same Database in Enterprise Gateway

            Currently we get a "Duplicate data source" error when trying to create a second connection with different credentials to the same DB.
            The use case is where we have both sensitive and non-sensitive data in a SQL database. We'd like to create two connections to this DB, so that a superset of users can pulish non-sensitive data, but only those authorised can publish sensitive data.

            107 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

              9 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
            • refresh failed

              Please add the name off Workspace into e-mail about Refresh failed. There is on Activity ID and Request ID and it would be really helpfull to know which workspace has trouble with refresh.

              Thank you

              1 vote
              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

                0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
              • Show Power BI gateway region

                Please show the region of the Power BI Gateway in Power BI Web Service : https://app.powerbi.com

                1 vote
                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

                  0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                • Show Power BI gateway region

                  Please show the region of the Power BI Gateway in Power BI Web Service : https://app.powerbi.com

                  1 vote
                  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

                    0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                  • Segmentation of schedule update time

                    The unit of update time using On-premises Data Gateway is [30 minutes], but please allow users to set the range of update time freely, such as 20 minutes.

                    2 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

                      0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                    • Refresh data upon change to the report

                      When the pbix file is updated (published via Get Data) or whenever a new pbix overwrites a current report, the dataset should be refreshed.

                      What happens currently is that the report may be weeks out of data when republished, and this old data replaces current data on apps (even without republishing). Instead, the dataset should always be refreshed when the pbix source changes.

                      14 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

                        1 comment  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                      • Gateway Management tool - CLI?

                        It is cumbersome to manage an Enterprise Gateway for 1000+ users using only the web gui. An ideal tool would be:
                        1) fast to return and submit information - no waiting for the web gui to load.
                        2) allow an admin to quickly add data sources & users, both one at a time and in bulk (perhaps by calling a function that takes a .csv of data as an input)
                        3) allow an admin to audit datasources, e.g.: view encrypted credentials; see how many datasets are connected; see how often refreshes are run, and whether they're succesful; return the M…

                        49 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

                          4 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                        • Service tags for NSG

                          Idea: Service Tags for PowerBI.

                          Issue: PowerBI Data Gateway is installed on Azure Server OutBound Security Rule needs to be setup on Server every time new server is set up creating manual work, for setting up outbound ports and IP address. Also Microsoft Azure Datacenter IP list is updated weekly which increases maintenance of updating IP address.

                          Solution/Request: Microsoft Provides PowerBI Service Tag which includes all Ports/IP(updated weekly) so that Outbound security rule can be setup in one place and no maintenance is required for weekly update of IP address.

                          8 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

                            0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                          • On-premise data gateway refresh fails when merging two tables from different web content sources

                            The problem appears when one of the tables uses two tables, that each of them is from different web.content source by merging them with m language.
                            When i try to refresh the model with service i get an error message:
                            "Cannot connect to the mashup data source. .."


                            When the model is using the same sources without merging them, all works fine.

                            1 vote
                            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

                              0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                            • GMSA Account for Enterprise Gateway

                              When setting up an Entreprise Gateway on PowerBI.com, in the manage gateways, data source setting page.

                              If I use Windows Authentication, I cannot put a GMSA (Group Managed Service Account) because the password field is required. GMSA account password are generated and maintained by the Key Distribution Service (KDS).

                              I would like to be able to use this type of account to configure Enterprise Gateway.

                              9 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

                                1 comment  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                              • OAuth to be made available for Enterprise Gateway

                                We are using Organizational account for connecting to OData feed in Power BI desktop. However, In Power BI service - OAuth authentication(which is required for Organization account) for adding the data source to Enterprise gateway is not yet available.
                                The only workaround for adding such data sources is to add such data sources is to create an API.

                                Kindly enable Organization Authentication in the Enterprise Gateway which will ease such issues.

                                21 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

                                  0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                • Allow dataset to refresh data sources from multiple on-premise data gateways

                                  Need to connect datasets to multiple on-premise data gateways without configuring the data source(s) on both gateways. For example, a dataset where datasource-1 is on gateway-1 and datasource-2 is on gateway-2.

                                  5 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

                                    2 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                  • recovery

                                    There should be a way to view the recovery key either on the gateway server or on the cloud service. In business, it is not uncommon for the original installer to move on to greener pastures ("get run over by the beer truck" as we say), taking the location of the recovery key with them. The new responsible party will then need this key.

                                    3 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

                                      0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                    • notes for gateway connections

                                      Need a note field in the Gateway settings that describes the connection it'll help in managing the Gateway connections

                                      2 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

                                        0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                      • PowerBI Enterprise Gateway for Linux

                                        Since it seems to depend on .net runtime only (at least more or less), why not port the gateway to linux? There are many customers who want to run linux only backends and are scared of having a windows machine running alongside their holy glory mission critical infrastructure...

                                        72 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

                                          6 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                        • List of users

                                          Be possible to extract list of users that are using connections within one Gateway. This will help on Change management process for notification in case the Gateway Server go through any change that requires outage.

                                          2 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

                                            0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          Power BI Ideas

                                          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.