Power BI Ideas

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

    251 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  2. Version history

    It would be nice with version history of the “Power BI On Premise Data Gateway” on the download webpage (and not very hard to implement).
    Since the first thing to consider when having problems with “Direct Query” is to have the latest version of the program it’s difficult to know if you do have the latest version.
    It is also not very efficient to have to reinstall on the server every time you have a problem if you are unsure which version is the newest …

    28 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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.

    50 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  4. Import/Export Data Sources into Gateway

    There should be a way to Export your data source settings from the PBI Desktop, and then Import them to the Data Gateway. This would greatly reduce the setup time.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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.

    119 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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.

    106 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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.

    49 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  8. Enterprise Gateway - adding new data sources

    Current pain: when adding a report (and data set) that rely on on-premise data sources, PowerBI assumes that a personal gateway will be used. This is not often correct. However, in order to make the dataset use an Enterprise Gateway, one has to be configured with matching data sources. To do this one needs to inventory data sources from the dataset and then create them (or add missing ones) to an enterprise gateway. It is painful today to determine what sources are missing (especially if something is misspelled slightly) and this is critical to ensure that the gateway can be…

    9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  9. Access as a Datasource for Enterprise Gateway

    Add ability for the Enterprise Gateway to refresh data from an Access Database

    62 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  10. Schedule Refresh Overview Screen / Tool

    When you have multiple data sets set to Schedule Refresh across multiple workspaces it can quickly become difficult to keep track of what is scheduled to run when. It can also become difficult to manage older versions of reports that no longer need to run, and ensure only what is required is scheduled.
    Other BI tools have a screen where you can see and manage all scheduled refreshes in one place. Without this some companies many struggle to replace other tools with Power BI.

    53 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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.…

    56 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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.

    44 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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.

    209 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    I modified the post to only show “Edit” . You can delete data source by clicking on “…” next to the Data source instance

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

    28 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  15. Installation rights for On-Premise Gateway

    Please allow specific AD group in the organization to install and manage On-Premise gateways. Not by default for everyone with admin rights. This is a key enterprise feature.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  16. active directory authentication

    Active Directory Authentication on a user/group level instead of authenticating a hardcoded single user.

    Right now, we have to maintain an access list in Power BI, eventhough all access rights is already maintained in our AD. How can we solve this, if we don't want to use Row Level Security or maintain access lists in Power BI?

    10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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.

    47 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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.

    36 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  19. Power BI Enterprise Gateway fails to set SESSION_CONTEXT when connecting to a SQL Server 2016 database

    The Power BI Enterprise Gateway does receive encrypted individual credentials from the Power BI Service for the user logged into the service, but it does not set the SESSION_CONTEXT in SQL Server for the the user logged into the service.

    As a result, SQL Server Row-Level Security does not work as expected when connecting from the Power BI Enterprise Gateway because a user as defined in the administration of the gateway is being used for all users.

    Since the encrypted credentials of the user logged into the service are being passed to the gateway, which is stated in the documentation…

    19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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…

    40 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  • 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.