Data Gateway - Can't acess GET DATA Analysis Services

[Anonymous]

Hi,

Since the last update of the On Premises Data Gateway "January 2018" my connections to Analysis Services are working as usual, refresh, schedule, publish but when we try do acess directly to the Cubes:

GET DATA -> DATABASES -> SQL ANALYSIS SERVICES -> MY CUBE

I get this generic error:

Something went wrong
Technical details:
Activity ID: -
Request ID: -
Date: 2018-02-01 09:19:18Z (UTC)
Error text: Ocorreu o erro de sistema seguinte:
Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net

Any suggestion?

[Anonymous]

We have found the error in the Gateway Logs and detected that the login user in O365 xpto@a.pt is not being passed to the Gateway, it reflects my corporative email a.b@c.pt

[DM.GatewayCore] Db pool opening raw database connection to [MSOLAP.5: <pi>MSOLAP.5:provider=MSOLAP.5;data source=SOURCE1;initialcatalog=CATALOG1;timeout=180;effectiveusername=a.b@c.pt;sspropinitappname=PowerBI:[Windows] Encrypted Credential information omitted</pi>]

[DataMovement.PipeLine.GatewayDataAccess] Replace effective user name in adomd connection string from a.b@c.pt to a.b@c.pt

[v-jiascu-msft]

Hi @Anonymous,

Did you solve your issue?

You can map the users to the proper account that the SSAS accepts.

Best Regards,

Dale

[Anonymous]

Microsoft resolved the issue...