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

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

      24 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 →
      • Data Gateway Scheduled Refresh for On-Premise Data Sources Should Include Shorter Timeframes

        Scheduled refresh currently has different time frames with the shortest being 15 mins. Some people require shorter time frames like 5 mins or 1 min. It'll be great to include this feature.

        10 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 →
        • Excel Online and Power BI gateway

          Make possible that Excel Online will try to use the Gateway to get data from on premise datasources. Currently you save a workbook to sharepoint online, a user tries to open it and it opens in excel online and he can not change the pivot table or refresh the connection

          4 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 →
          • support "Publish To Web" also for "Analysis Services"

            Have several OLAP cubes and prepared Power BI reports on it which I can act on within PowerBI Services.
            I want to offer these reports also within a corporated intranet site but the feature "Publish To Web" is not yet supported (in 11/2017)
            https://powerbi.microsoft.com/en-us/documentation/powerbi-service-publish-to-web/

            2 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 →
            • Updating data source/dashboard/report

              It is very problematic when you create a report/dashboard in Power BI Desktop then publish it to your workspace, then you have to make an update in Desktop, publish again then try to refresh in your workspace but actually you have to go to a 3rd place (gateway) to update the data source. Now we're doing too much.

              2 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 →
              • Create 'Global Table Refresh' structure

                Each table used in at least one dashboard is set to refresh [needs an increase in options on this one] by a variable integer of hours, days, weeks, months, etc. Then any dashboards needing to connect to that table would be able to refresh as often as the table or less frequent, so that each table in the Gateway is only pinged once regardless of how many reports/dashboards it lives in. Also significantly reduces the number of 'GET' creations are needed if I have a 'STORE' of the GETs I use now already being refreshed.

                3 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 →
                • Oracle Connection

                  The Oracle connection wizard states Server but in fact it is the TNS Names alias for the database, please could this be relabelled.

                  2 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 →
                  • Enhance Refresh Failed Email Notification to Inclue a Link to the Dataset

                    Include a link in the body of the Refresh Failed email notification to the actual dataset that failed in order to save time trying to figure out which workspace a dataset resides.

                    12 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 →
                    • Append Excel table located on OneDrive with Oracle on prem. data in a query and refresh in Power BI Service

                      I have a data model that has one query that pulls data from an Excel table saved to OneDrive (SharePoint Online) and another query that pulls data from an Oracle table. I am able to append those two tables together in Power BI Desktop and refresh. However, when I publish the model to Power BI Service this append step breaks the ability to enable refresh on the enterprise gateway.

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

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

                          3 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 →
                          • CRON

                            Use CRON expressions to set up data refreshes.

                            1 vote
                            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 →
                            • Oracle Import Data Connectivity Mode

                              Allow Import Data Connectivity mode for Oracle databases.

                              1 vote
                              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 →
                              • App Workspace Report Level Permissions

                                Currently --- In an APP Workspace we can set APP Workspace permissions. "Members Can Edit Power BI Content" or "Members can only view Power BI Content".

                                We need to be able to set permissions on a Report (Individual R/W or R/O) to "lock down" the reports in case someone edits or deletes someone else's report. This would also allow creating a "Template" report that is R/O so that users could "Save AS" and use it to create their own. Default permission would be R/O for everyone except "Owner" and "Admin"

                                6 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 →
                                • Gateway on Linux, and Multiple Domain Account on one Gateway

                                  We need:
                                  - create gateway for Linux (we have linux enterprice PCs, but we must have hole Windows-machine only for using Power BI GateWay)
                                  - add multiple accounts from different domain support (we cant create different pay subscriptions even we have several domains, so we must register separate subdomains. But in this case we have to use two gateways, and as result - two windows machines only for gateways)
                                  - add possibility to set custom emails for error notification after update error (now email notification after gateway update error not works)

                                  3 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 →
                                  • database as optional in gateway

                                    In Power BI service, in data gateway i want to add a new data source, so i choose "sql server" and because there are many databases i dont want to choose only one database. Why this field is not optional?

                                    4 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 →
                                    • Separating the roles of Power BI/Data Gateway administrator from the custodian of data connection

                                      Currently, the person who can setup a data connection – entering “hard-coded” credentials – on a Data Gateway has to be also an administrator on the Gateway.

                                      It means that either a Power BI admin has to have access to Data Connections (including sensitive data), or a Data Custodian has to become an admin on the Gateway (and be able to affect other “tenants”/data connections deployed on the same Gateway). Running a separate Gateway per each data connection is not economically feasible.

                                      POSSIBLE SOLUTION: Change the Data Connection object so that connection credentials can be stored outside of the Data…

                                      2 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 →
                                      • Gateways > Add Data Source is hidden until you hover it

                                        I just wasted 30mins trying to find the add data source button only to discover it only appears when you hover over the gateway name.
                                        Insane.

                                        1 vote
                                        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 →
                                        • Mobile settings to incorporate gateway

                                          It would be great to be able to edit a gateway through the mobile app if my account is an admin. I cannot trouble shoot a gateway issue though my mobile app and would prefer to have that ability without having to use Remote Desktop.

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

                                          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.