Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Better Tools for IT to Support Gateway Refresh issues

    We need better/more enterprise tools for IT to SUPPOT all of BI; especially the disabled gateway refreshes after a connectivity/ server issue. We are supporting 30+ workspaces and that is growing every day. When the schedule report refreshes are automatically disabled we have to manually access each workspace, each report etc. to turn the refresh back on. We need enterprise views to support and fix issues like this across all of our workspaces, gateway tools etc. to review total space utilization etc.

    1 vote
    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 →
  2. Microsoft Exchange connection for gateway

    Please add a gateway connection to be used with Microsoft Exchange. I have been wanting to connection to particular folders/files within my Office 365 Mail that can be brought in through Power BI Desktop, but then cannot be part of a published model using gateways due to the lack of this Microsoft Exchange Gateway

    10 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 →
  3. 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…

    31 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 →
  4. Reenable Scheduled Refresh After Updating Shared Access Signature

    The problem:

    1) Create a report with a shared access signature URL (see https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9953427-connect-to-azure-tables-via-shared-access-signatur).

    2) Publish the report with auto refresh enabled

    Now, when the shared access signature expires, the auto refresh fails, and the web site disables scheduled refreshes, saying that you need to go to Settings->Datasets->Data Source Credentials and reenter the credentials.

    HOWEVER, that is not where the credentials are stored (they are part of the URL). Updating the URL and re-publishing the pbix doesn't re-enable auto refresh.

    FURTHER, the Data Source Credentials setting is greyed out, so there is absolutely no way to update the credentials.

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

    21 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 →
  6. View List of Reports Associated with a Gateway

    In the Power BI Service, gear icon menu, under 'Manage Gateways', would you consider adding a 'View Associated Reports' option to the menu that's displayed when "..." is clicked by a data gateway's name?

    Use Case:
    When migrating from an old gateway to a new gateway, the web interface doesn't provide a way to see which reports are associated with the old gateway and so need to be updated to use the new gateway. In the self-service BI world, the IT administrator doing the migration may have no idea which gateway each report uses so may need to visit all…

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

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

    1 vote
    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. 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
    (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 →
  9. 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
    (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 →
  10. 1 vote
    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 →
  11. 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
    (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 →
  12. 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

    2 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 →
  13. 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
    (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 →
  14. Gateway deletion

    Considering that a Gateway is very easy to be removed by human error, Will be considered in the next Gateway releases implement some deletion method (similar to the one used in Azure Portal for resources where you need to type the name of the resource as a security measure)? What happens if a gateway is deleted from the Power BI service? I'll not be able to recovery anymore right?
    At least consider in having the two functionalities ( Add Data Source / Remove) separated from the gateway “right click” options.

    6 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 →
  15. Row level security

    It would be great if we can have dynamic row level security without adding members each time. I use RLS on a dataset that has 8000 records, and typing each member to a group space is a tedious task!

    4 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. support direct query excel

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

    4 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 →
  17. 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.

    13 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 →
  18. 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
    (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. moving data sources between gateway clusters

    Hello,
    It would be great if we have the ability to move data sources between gateway clusters so that we could use gateway cluster groups as categories etc or merge data sources that have initially been created in different clusters but are using the same gateway into one cluster.

    Thank you

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

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