Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi everybody,
after the new feature within the enterpise gateway has been released(https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud) I tried to replace my personal gateway which combine a mysql database connection and a sharepoint with an enterprise gateway. But if I try to setup the Sharepoint connection within the new gateway I got the following error:
OVIP_LUGERHAMVM010:
Ungültige Anmeldeinformationen für die Verbindung.
Zugrunde liegender Fehlercode:
-2147467259
Zugrunde liegende Fehlermeldung:
The credentials provided for the SharePoint source are invalid. (Source at https://federations.sharepoint.com/sites/lsxxx.)
DM_ErrorDetailNameCode_UnderlyingHResult:
-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:
SharePoint
Microsoft.Data.Mashup.CredentialError.DataSourcePath:
https://federations.sharepoint.com/sites/lsxxx
Microsoft.Data.Mashup.CredentialError.Reason:
AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources:
[{"kind":"SharePoint","path":"https://federations.sharepoint.com/sites/lsxxx"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:
AccessUnauthorized
Within the PowerBI Desktop I use the OAuth2 method to connect ot Sharepoint. This option is not available within the gateway and my Emailaddress and Password which I normally used to Login to Office365 is not working(the error mentioned above occur)
If I try to setup the gateway connection for the mysql server the following error occur
OVIP_LUGERHAMVM010:
Es konnte keine Verbindung mit der Datenquelle "undefined" hergestellt werden.
Zugrunde liegender Fehlercode:
-2147467259
Zugrunde liegende Fehlermeldung:
MySQL: Unable to connect to any of the specified MySQL hosts.
DM_ErrorDetailNameCode_UnderlyingHResult:
-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:
MySql
Microsoft.Data.Mashup.ValueError.DataSourcePath:
db40XX.mydbserver.com;usr_pXXX
Microsoft.Data.Mashup.ValueError.ErrorCode:
-2147467259
Microsoft.Data.Mashup.ValueError.Message:
Unable to connect to any of the specified MySQL hosts.
Microsoft.Data.Mashup.ValueError.Reason:
DataSource.Error
Solved! Go to Solution.
The problem was caused by the firewall where some ports has been blocked.
The problem was caused by the firewall where some ports has been blocked.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.