Cannot process database. Reason: Failed to save modifications to the server.

[leventgundogdu]

I created a tabular project on analysis server using AdventureWorks2019 database. I succesfully imported the table I wanted to but when I deploy the project it gives the below error which is:

Cannot process database. Reason: Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: The credentials provided for the SQL source are invalid. (Source at msi;AdventureWorks2019.).

Does anyone have an idea of why this is happening?

[leventgundogdu · Accepted solution]

I created a local account with a password(I was signed in with a windows account before) then when I tried to deploy the project, it worked. 

[DoubleJ]

You probably need to enter the credentials in SSAS. You can do this using SQL Server Management Studio:

Hope this helps
JJ

[leventgundogdu]

I did what you asked and it still didn't work. I entered the server with the "impersonate service account" option, and it successfully entered the server and pulled the information from there. I think the problem is with the analysis services since I can do everything but process the changes. 

Thank you for your answer