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. More control of SSAS direct query cache refresh

    There needs to be more control over the automated cache refresh for Direct Query connections, specifically to SSAS.

    At present Power BI reruns all recent queries (for each individual user, when there's row level security) as soon as it detects any processing on the cube.

    If a cube is processed in separate batches then this adds an incredible load on the SSAS box when we're trying to continue processing.

    Additional options are required including:
    - Disable auto cache refreshing
    - Disable auto cache refreshing between certain times
    - Only auto refresh the cache when measure groups are processed, not dimensions…

    33 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 →
    • Have one gateway connection for multiple databases in an instance

      Have one gateway connection for multiple databases within an instance so that you don't have to manage multiple database connections for the same instance.

      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

        0 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

        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

          0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
        • Ability to amend Gateway Owner

          Provide the ability to change ownership of On-Premise Data Gateway object; right now only the owner (who installed the Gateway) can upgrade the gateway to a new version without creating a new Connection Object in Azure (creating a new connection object would require migration of all connections i.e. LogicApps to this object).

          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 →
          • Problems to connect the gateway with analysis services (Discover Method)

            I'm trying to connect the analysis services, but when I configure my user in Gateway in Power BI On line give this error:

            Não é possível conectar: Encontramos um erro ao tentar conectar a . Detalhes: ""Ocultar detalhes
            ID da atividade: b2dd5e35-7581-45bd-b3ae-99464b2c08c6
            Solicitar ID: 5f789075-f508-7dd7-7866-24f377efb120
            Cluster URI: https://wabi-south-central-us-redirect.analysis.windows.net
            Código de status: 400
            Código de Erro: DMTS_UpdateClusterDatasourceCredentialsErrorCode
            Hora: Fri Feb 08 2019 09:23:14 GMT-0300 (Horário Padrão de Brasília)
            Versão: 13.0.8234.157
            DashboardProjetos: Atingimos o gateway de dados, mas o gateway não pode acessar a fonte de dados local.
            Código de erro subjacente: -1055391722
            Mensagem de erro subjacente: O usuário 'username' não tem…

            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 →
            • Cancel an ongoing refresh

              Ability to cancel an ongoing refresh. This would give the ability to look into an issue without waiting on the error to appear after a considerable amount of time.

              41 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 →
              • Add day option on schedule refresh, my gateway is down ever weekend.

                Add day option on schedule refresh, my gateway is down ever weekend.

                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 →
                • Details on refresh time

                  I would like to see time it took to refresh each dataset in auto-refresh. This will help me identify if I need to optimize my queries or use different data source etc. For my application, refresh duration of 5 min vs 10 min makes a huge difference.

                  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 →
                  • Named Databse connection in Gateway

                    Allow "Named" Connections in Gateway. This way we don't need to change the connections when moving from Dev to Prod.

                    Example:
                    Assume I build a report and am testing it through my test Gateway and test database (DB_TEST).
                    Now I want to start using my Prod Gateway and use the Prod database(DB_Prod).

                    Currently I need to change the DB Connection in all the reports to DB_Prod to start using Prod.

                    It would be simpler, if the connection was not based on the Database directly, but based on the names in Gateway.

                    Then Test Gateway would have a connection named DB…

                    29 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 →
                    • автопереключение между щлюзами

                      При сбое на корпоративном сервере обновление не осуществляется. Предлагаю сделать автопереключение между шлюзами при неудачной попытке обновления по одну из них. Для набора данных указывается приоритетный шлюз, например корпоративный, и если по нему возникает ошибка, автоматически осуществляется попытка обновиться через локальный и наоборот.

                      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 →
                      • .xlsb Excel file data refresh support

                        .xlsb Excel files can be loaded in Power Bi Desktop. Unfortunately the data refresh via a gateway is not possible and fails.

                        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 →
                        • You have no personal gateways installed

                          There is a prompt says that "you have no personal gateways installed" , but as you know ,I have installed the On-premises data gateway and it is running smoothly ,and I think this prompt is confusing

                          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 →
                          • Service principal with Power BI and Data Gateway

                            Currently the Service principal account cannot leverage the On-Premises Data Gateway since it is not a mail-enabled account. This prevents a Power BI Embedded solution to leverage an on-premises SSAS tabular model leveraging the service principal. Instead we need a full-blown power BI pro license for a service account. I would like the capability to leverage the data gateway added to the service principal Power BI authentication.

                            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 individuals to be set as Data Source Admins

                              Currently there are admins for the gateway who can admin the environment and the data sources and users who can access specific data sources. There should be an intermediate level of admin capabilities that would allow PBI Gateway admins to assign users the rights to administer specific data sources. Our issue is that the passwords for the service accounts that are used in the DSN change regularly. As usage of the gate2way grows it will become unworkable for an individual or group to manage all the various DSNs in an organization. The DSN admin should have rights to modify any…

                              19 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 →
                              • logically group gateway's datasources

                                The ability to group the datasources on a gateway to group either by affinity or by a same concept, or same group of sources, etc. This is just a logical aggregation for easy administration purposes only.
                                Say I have 10 files the serve for several reports, I'd like to group all those 10 datasources on the gateway to be sure all are ok or to add just there to keep naming convention between them, for instance.
                                I posted it, it's your turn to vote.

                                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 →
                                • 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 →
                                  • Refresh Failure Email Summary

                                    It would be great if instead of one email per failure, we could get a summary email of all failures. I am the "owner" of close to 100 reports and when there is a gateway (or other) issue I receive close to 100 emails.

                                    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 →
                                    • Power BI Enterprise Gateway for report on both OnPremise & Cloud data sources

                                      Power BI Enterprise gateway can not refresh (schedule or on demand) Power BI reports created on both On premise and Cloud data sources. As suggested by Microsoft, as part of a incident, to use personal mode Gateway for such case when a report uses both On premise and Cloud data sources. But personal gateway is not a good solution for business use.
                                      So can Microsoft implement this feature in Enterprise Gateway that it can refresh a report based on both on premise & cloud data sources.

                                      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 →
                                      • Allow Automation for ON-premises installation

                                        Allow Automation for ON-premises Gateway installation.
                                        We have 20 Servers with Enterprise Gateways install on them.
                                        As new versions come out, we want to update the Gateway on all servers. However, we can not use a silent install since it is non-existing feature. We have to go server-by-server and install the gateway and then configure it. Please allow silent install just like SQL Server

                                        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 →
                                        • Use SQL Server Management Studio a gateway for Power Bi

                                          Connecting Power Bi to Azure SQL databse is practically impossible. I know you can do it because SQL Server Management Studio CAN connect. Why? Because you can use connection strings. You could either just use what the SSMS folks already did without building a gateway. It is very frustrating how disparate Microsoft apps are. Power BI is infinitely harder to work with.

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