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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Tishchenko
Continued Contributor
Continued Contributor

New Enterprise Gateway and SSAS connection over http (MSMDPUMP.dll)

Seems this version don't support http-to-AS tecnology.
My admin allow connection to SSAS only over https 443.
Sample of server name in connection like this "https://server/as/msmdpump.dll".
But Gateway return error 400 DM_GWPipeline_Gateway_DataSourceAccessError.
We temporarily open SSAS port in firewall to check statdart connection type over TCP and gateway connected and works ok.

Untitled.png

 

this technology http-to-SSAS works fine in Power BI desktop:

Untitled2.png

 

 

1 ACCEPTED SOLUTION
Tishchenko
Continued Contributor
Continued Contributor

Ok, this bug was fixed in  latest Enterprise Gateway (GA). Works fine!

dump.png

View solution in original post

4 REPLIES 4
joanperez
Advocate II
Advocate II

Same situation, with the same behavior...  😞

 

BIGatewayError.jpg

jat75
Advocate II
Advocate II

We are experiencing the same issue! Please vote for our suggesstion.

https://ideas.powerbi.com/forums/265200-power-bi/suggestions/7266252-support-ssas-connection-using-h...

Tishchenko
Continued Contributor
Continued Contributor

Ok, this bug was fixed in  latest Enterprise Gateway (GA). Works fine!

dump.png

Even we used the latest verison of BI Enterprise Gateway (downloaded from app.powerbi.com on Apr 22, 2016), but still have the below error message and screen capture as shown in below..


We can connect the Analysis services by using the same link and login with on-premise SQL management studio in SQL 2012, thus, it is ensure that the URL and login account is working even access remotely)

 

Any suggestion?

 

 

Unable to connect: We encountered an error while trying to connect to http://XXX/OLAP/msmdpump.dll. Details: "Invalid connection credentials."Hide details

Activity ID:

abee7851-2c6d-1a0e-956f-ac30e4491198

Request ID:

27fa924f-d1ea-5187-1543-d5a407dd9d95

Cluster URI:

https://wabi-south-east-asia-redirect.analysis.windows.net

Status code:

400

Error Code:

DM_GWPipeline_Gateway_InvalidConnectionCredentials

Time:

Fri Apr 22 2016 13:05:04 GMT+0800 (China Standard Time)

Version:

13.0.1100.351

 

Underlying error code:

AuthenticationFailed

Underlying error message:

The connection either timed out or was lost.

DM_ErrorDetailNameCode_UnderlyingHResult:

-2146233088

Troubleshoot connection problems

 

 

 

 

gatewayerror.jpg

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors