Large SAP BW installations with thousands of users are often accessed via single-sign-on (SSO) e.g. the users windows credentials are used to authenticate to BW. SSO simplifies the user experience and reduces user administration costs. These users should be able to setup on-premise gateway connections that can be used to refresh data sets in the Power BI Service. The connections should leverage that individuals BW roles & authorizations and not require a BW password i.e. automatically associate the Power BI user ID to the associated SAP user ID.

As Power Bi and other applications in the Power Platform become more prolific within the BI Cloudscape and Landscape integration, gateways will become used more and more. Having visibility to the capacity of a gateway, the volume of traffic through the gateway, which datasources are used more frequently than others, which types, etc would be a very useful resource to have within the Gateway management system.

It would be very interesting to have the option to see the activity carried out through the gateway in the Power BI service, so that it can be seen in a simple way, the actions of updating the data sets that has been carried out from a gateway / connection, by way of the update history of the data sets but from the administration of the gateway.

Currently, the data sources under the data gateway don't have any order. Could you sort them at least by the name? It's hard to work with multiple data sources when they are spread randomly on the list.

We need ability to monitor gateway refreshes in real-time:
-have an overall view of what's running right now: datasets, workspace, gateways, memory, CPU. We have it in the PBI capacity metrics, but only, the day after that is not helping for live monitoring.
-ability to cancel a refresh when it has started
-use past stats to provide some ETA on refresh currently running, and provide a way to display that ETA on a report
-see the "true" current state (not just the wheel running) often it's broken but we see the error only 2 hours after
Thanks!

It would be very useful to have a progress bar when refreshing a dataset in the Power BI Service interface.
A step further would be to have the progress in general for the dataset and separately for each of the data sources in the dataset.

In the gateway data source I am forced to add each user individually to allow them to create a report off that data source.
Alternately I can create custom groups in o365.
We have already established security groups on our system would it be possible for these groups to be used?
This is an extra layer of security for hundreds of users that has already been solved through active directory synchronization with office 365.

The use case is to add a security group or multiple group to be authorized to create reports off the data source. When we add or take out personnel
from the security group it will propagate up to Power BI.

In the gateway data source I am forced to add each user individually to allow them to create a report off that data source.
Alternately I can create custom groups in o365.
We have already established security groups on our system would it be possible for these groups to be used?
This is an extra layer of security for hundreds of users that has already been solved through active directory synchronization with office 365.

The use case is to add a security group or multiple group to be authorized to create reports off the data source. When we add or…

Hi, I really appreciate the email that is generated when the scheduled refresh failed. Would it be possible to add there:
- name or ID of workspace failed report is in?
- information why it failed (eg. "Could not resolve QueryDefinition due to invalid SourceEntity reference '<pi>_MyMeasures</pi>'. This error often happens after the Entity was renamed or deleted. Please update the query/visual to use the new name or undo the name change. - Source: 'User' "

It would be very helpful for us, who have many workspaces and need to know what is wrong.

In Power BI gateway we have available features to add and remove connection; but we do not have anything like enable/disable. However a feature to be able to disable connection will be helpful when resetting/changing password in a connection. Or sometime we want to hold a particular database to be accessed from Power BI when some maintenance activity is in progress in that database. So it would be helpful if we can control the connectivity to different sources in the gateway using disable/enable.

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.

Currently only one connection is allowed on a system in the gateway. We have multiple market implementation which requires different logon id for each market but connecting to the same system. Currently this is not possible on a single gateway. This requires adding additional gateway.

Usage Report for Enterprise Gateway - The log data should be available so that we can create dashboards based on Gateway Usage data.
Metrics like the datasets name using Gateway, workspace name, owner, scheduled refresh frequency, adhoc refresh, run duration and other parameters for all dependent reports should be available. This will help in scaling the Enterprise Gateway correctly and avoid bottlenecks. Currently there is no visibility to the work spaces for which we don't have access however responsible for maintaining gateway.

Ready to get started?

Power BI Newsletter

Take your data to the next level with the best tips and tricks from our experts.

Thanks for signing up for the Power BI newsletter.

By clicking Sign up, you are giving your consent to Microsoft for the Power BI newsletter program to provide you the exclusive news, surveys, tips and advice and other information for getting the most out of Power BI. You can unsubscribe at any time.

Downloads

Whether you are on the go or need to create rich, interactive reports, Power BI offers you the tools you need.