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

    74 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 →
    • Schedule data refresh cancellation update

      I have multiple reports that update hourly. These cannot be direct query due to different data type requirements. Our gateway often (not always) shuts down in the weekend or at night. Since my report updates hourly, the dataset will disable refresh. I would prefer is the disable was setup so that it lessened the frequency of the refresh (hourly to daily) after 2 failed refreshes, and then only disabled after 2,3 more tries. That way, one gateway reset did not disable the auto refresh

      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 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 →
            • support direct query excel

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

              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 →
              • 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.

                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

                  7 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 →
                  • 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 →
                    • 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…

                      47 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 →
                      • 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 →
                        • 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.

                          20 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 →
                          • 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.

                            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

                              1 comment  ·  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 →
                              • 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...

                                54 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 →
                                • When adding a datasource to a gateway, allow the 60 second timeout to be changed

                                  When adding a datasource from my on-premise MySQL database, Power Bi will send a query to my Information.Schema table that can take over 60 seconds to query (depending on the database). Since it keeps timing out, I am unable to add the datasource which prevents me from setting up scheduled refresh times. It would be nice to either have the option to change this timeout interval or change the default query Power Bi makes to my database.

                                  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

                                    1 comment  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                  • On Premises Data Gateway/Dataset - Email notification when failure improvment

                                    I have just experienced a bad weekend return. All users complaining that their reports/dashboards were not operating anymore.

                                    I quickly discovered that both On Premises Gateways (DEV and PROD) were "down", "Unable to connect: The gateway is either offline or could not be reached".

                                    Microsoft support did not provide a reason, but instead suggested frequent update of the OPG, as well restart of the associated Services on the machines when something is going wrong.

                                    I asked why should we wait for end users to complain, prior taking action, as PowerBI service knows there are some refresh issues, as this is…

                                    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

                                      1 comment  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                    • DirectQuery mode for Impala over the Gateway

                                      PowerBi Desktop is working with Impala in SSO/kerberos using Import or DirectQuery mode.

                                      The gateway only accept Import mode for Impala.
                                      Please develop the DirectQuery mode for the Gateway

                                      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

                                        1 comment  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Option to disable parallel loading or limit data source connections.

                                        Currently the on-premises gateway opens more Oracle connections that we have license for.

                                        7 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 →
                                        • Provide full Personal Gateway functionality for those with 32-bit Windows

                                          Due to the limitations of other business applications that may not have been upgraded or can not be upgraded, many business users are forced to stay with a 32-bit Windows.

                                          By limiting the Personal gateway to only 64-bit, it prevents the use of this feature by those that may be best argue for upgrades to other applications by using Power BI to show the metrics and other data to make the business case for being current.

                                          108 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

                                            26 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.