Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
@Anonymous , It seems more like an issue with user or permissions.
Hi,
yes, user permission access issue. I Enabled sysadmin tick mark then it's working fine.
Hi,
yes, user permission access issue. I Enabled sysadmin tick mark then it's working fine.
@Anonymous , It seems more like an issue with user or permissions.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
67 |