Forum Discussion
Solved
Data source access error. Tabular Live connection to local host
Hi,
I have:
- admin company account "[email protected]"
- Tabular SSAS located on DESKTOP-123 with admin user "Adm"
- gateway set up to SSAS Tabular service with Windows authentication method and "adm@DESKTOP-123" as username.
- report + dataset which should work via gateway and get data from SSAS Tabular.
When accessing report I got "There was a data source access error. Please contact the gateway administrator.".
Given that local workstation is not in @company.com domain I create a manual user mapping for gateway:
Anyway that doesn't help as in Gateway log I still have error:
Spoiler
GatewayPipelineErrorCode=DM_GWPipeline_Gateway_DataSourceAccessError
GatewayVersion=
ErrorCode=-1056899072 --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: AdomdErrorResponseException:<pi>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The following system error occurred: We can't sign you in with this credential because your domain isn't available. Make sure your device is connected to your organization's network and try again. If you previously signed in on this device with another credential, you can sign in with that credential.
GatewayVersion=
ErrorCode=-1056899072 --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: AdomdErrorResponseException:<pi>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The following system error occurred: We can't sign you in with this credential because your domain isn't available. Make sure your device is connected to your organization's network and try again. If you previously signed in on this device with another credential, you can sign in with that credential.
What am I doing wrong?
- Hi there
When using On-Premise SSAS you have to use DOMAIN\Username as the username. Along with this your SSAS Server should be part of a domain.
The On-Premise SSAS does not understand adm@DESKTOP-123. You could try DESKTOP-123\Adm as the username.
Use the same username and password you use when logging into your SSAS instance locally on the server (DESKTOP-123)
1 Reply
- Hi there
When using On-Premise SSAS you have to use DOMAIN\Username as the username. Along with this your SSAS Server should be part of a domain.
The On-Premise SSAS does not understand adm@DESKTOP-123. You could try DESKTOP-123\Adm as the username.
Use the same username and password you use when logging into your SSAS instance locally on the server (DESKTOP-123)