permissions to refresh a data model in azure analysis services

Question

I am refreshing a data model in Azure Analysis Services using an Azure Function App (C# .NET 6). I am using the Microsoft.AnalysisServices.Tabular package available at https://www.nuget.org/packages/Microsoft.AnalysisServices.NetCore.retail.amd64. When I have read access rights, which have i have been correctly added as a role user and granted permissions for in Azure Analysis Services using ad, the model refresh does not work. I get the following error: 'Azure Analysis Services database not found' (this is because it can't read the Analysis Services DB). I also cannot see the Azure Analysis Services database in SQL Server Management Studio. I can connect to the server, however, I can't expand to see the model. After this, I tried the same for process role permissions and the exact same thing happened. Following this, a new role was created with both read and process rights, which was granted correctly, again getting the same error. I finally tried with admin rights, and the model refreshed correctly. When i log in to SQL Server Management Studio and connect to azure analysis services. If i go into the database section i can click into it and correctly see the azure analysis services database (the model i will be refreshing). The problem with admin rights is that it grants high-level permissions to everything, which is bad for security, and as user i should not allowed admin rights. Are there any permissions that are lower then admin that could allow me to refresh the data model. any workarounds? I expected that read and process rights would be high enough to do what I am doing but it doesn't work

Answer 1

See Grant process permissions (Analysis Services)