Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am working on a power BI report to pull data from SAP BW system. I can connect to SAP BW from Power BI desktop and was able to publish to the portal.
I would like the super user to edit and run the report as needed and I thought to use on-premise gateway to refresh the data on the portal. I've installed and configured on-premise gateway and was able to connect to SQL server from the powerbi.com portal. However, when I want to add the data source for SAP BW then I'm getting the following error.
My questions are.
1) I would like to know what's the best approach to deliver the report to super users who can customize and run the report to the portal.
2) Is there anything that I'm missing for connecting to the on-premise gateway.
Thanks.
Error message:
Unable to connect: We encountered an error while trying to connect to <>. Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
powerbigateway01: | Invalid connection credentials. |
Underlying error code: | -2147467259 |
Underlying error message: | RfcOpenConnection failed(RFC_LOGON_FAILURE): Password logon no longer possible - too many failed attempts |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.CredentialError.DataSourceKind: | SapBusinessWarehouse |
Microsoft.Data.Mashup.CredentialError.DataSourcePath: | |
Microsoft.Data.Mashup.CredentialError.Reason: | AccessUnauthorized |
Microsoft.Data.Mashup.MashupSecurityException.DataSources: | |
Microsoft.Data.Mashup.MashupSecurityException.Reason: | AccessUnauthorized |
Hi @biflake,
1. You can create a app workspace and publish the report to this app workspace, add these super users as app workspace with Edit permission. So these users can edit reports by themselves. See: https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps
2. From the error message, it seems there is a issue with credential entered when you create a SAP BW data source in the gateway. As you can connect to SAP BW successfully in Power BI desktop, ensure you use the same credential as in desktop.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.