Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
HaraldK
New Member

Connection to SQL via Data Gateway fails: Error occurred while decoding OAEP padding.

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.

2 REPLIES 2
Anonymous
Not applicable

@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

poncoy
Frequent Visitor

Hello. You use the Personal Gateway or the Enterprise Gateway?

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors