Forum Discussion
Unable to connect to on-premise SSAS tabular model
Hi Community,
I'm trying to connect to a on-premise SSAS tabular model (MSSQL BI 2014) via on-premise enterprise gateway.
Below steps are performed:
1. Install the gateway
2. Enable Azure Service Bus connectivity mode
3. Add tabular data source in powerbi and connection test is successful.
4. Do the user name mapping ex. [email protected] (my powerbi login) to [email protected] (whoami /upn)
5. Connect to the data source and return "Something went wrong" message.
6. Export the log with a suspicious message:
[DataMovement.PipeLine.GatewayDataAccess] Replace effective user name in adomd connection string from [email protected] to [email protected].
7. The message seems didn't actually doing replacement (company.net vs company.net)
Any idea? Thanks.
ps. I can access the on-premise MS SQL via the gateway.
The link I followed to perform username mapping is
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-ssas/#map-user-names
1 Reply
- v-qiuyu-msft
Community Support
Hi paulwsc,
Do those two domains have trust domain relationship? If it's trusted, you needn't to add match user name roles in data gateway. See this similar thread: On-Premise Gateway not passing logged in users EffectiveUserName to Analysis Services.
Best Regards,
Qiuyun Yu