Forum Discussion

CSun's avatar
CSun
Frequent Visitor
9 years ago
Solved

Tabular model process failed with DM_GWPipeline_Gateway_DataSourceAccessError

I have an AzueAS pulls data from on-prem SQL. I have 2 models already existing and migrated the gateway to new server.    I created a new model and deployed. The deployment succeeded, but processig...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    CSun,

    Double click the data source in the Analysis Services project, click “Impersonation Information” tab, if you selected “Use the service account”, please make sure that the service account has access rights to the relational data source.

    Or you can select “Use a specific Windows user name and password”, enter your account that has access permission on the relational data source, then re-process the project.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

CSun,

Double click the data source in the Analysis Services project, click “Impersonation Information” tab, if you selected “Use the service account”, please make sure that the service account has access rights to the relational data source.

Or you can select “Use a specific Windows user name and password”, enter your account that has access permission on the relational data source, then re-process the project.

Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I am still getting attached error while my database works fine.

Any suggestion what I am missing here ?