Power BI Ideas

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

    10 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. Chose the TIME for a scheduled refresh on more than the hour and half hour mark

    ///// WHY? Our people have lunch break from 12 - 12:30. So I shouldn't schedule a refresh of their time sheet data at either time. It should be 12:15. That's currently impossible with the gateway connector. Other similar scenarios beg for the ability to schedule a refresh during the workday at an odd time. Please, please AT LEAST give us the quarter hour as an option.

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

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

    We’ll send you updates on this idea

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

    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 →
  6. Folders to Organize Connections in Gateway

    When the number of connections increases in the gateway, the list gets longer and harder to manage. In my company we have ~40 connections configured and growing quickly.
    I'd like to see ways of organizing the connections into folders (could have it based on a business unit , application etc.) .
    At the very least, please make the sequence of connection names alphabetic

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

    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 →
  9. 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
    (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. Additional Data Set Refresh Metadata (Rows Refreshed/Loaded)

    Need to be able to monitor health of refreshed dashboards and troubleshoot if necessary. From time to time a dataset will successfully refresh with zero rows due to operational issues. Can additional dataset refresh metadata be made available to give visibility?

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

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

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

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