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.
Get this error when trying to connect to our SQL Server on-premis using enterprise data gateway, and when using File option.
Unable to connect: We encountered an error while trying to connect to SQLServer. Details: "There was an error in the data gateway."Hide details
Status code: | 400 |
Error Code: | DM_GWPipeline_UnknownError |
Time: | Thu Aug 24 2017 13:28:47 GMT+0200 (Central Europe Daylight Time) |
Version: | 13.0.2136.181 |
Underlying error message: | Error occurred while decoding OAEP padding. |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2146233296 |
I connect with windows credentials, credentials are working from the Data Gateway server,
I installed the gateway to days ago, should be the latest version.
Any ide why this message is happening? I found something on the community, a suggestion to replace the msolap.dll file, however the file is not longer accessible from the forum.
@HaraldK,
Do you use "File" data source type in Gateway to add the SQL Server data source? If so, when adding SQL Server data source within gateway, we need to choose "SQL Server" type, please follow the guide in this article to perform the process.
Regards,
Lydia
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.