Loading tables into SSAS Tabular model

[Anonymous]

Hi team,

I downloaded SSDT tool recently and i am trying to connecting my table from SSMS. But here, when i load the table into SSAS error will generated.

Failed to save modifications to the server. Error returned: 'Either the database with the ID of '1First Project_admin_b1e1a79d-87ea-4352-b749-b15e99c328c2' does not exist in the server with the ID of 'DESKTOP-5BFG5R2', or the user does not have permissions to access the object.

here,

Tabular Cube Name:  '1First Project_admin_b1e1a79d-87ea-4352-b749-b15e99c328c2' 

SSAS Server Name : 'DESKTOP-5BFG5R2', 

can you please help me how can i reslove this issue.

Adv Thanks

Naveen

[amitchandak · Accepted solution]

@Anonymous , It seems more like an issue with user or permissions.

[Anonymous · Accepted solution]

Hi,

yes, user permission access issue. I Enabled sysadmin tick mark then it's working fine.

[amitchandak · Accepted solution]

@Anonymous , It seems more like an issue with user or permissions.