permissions to refresh a data model in azure analysis services

Muhammad Pathan 25 Reputation points
2024-02-19T11:10:09.8366667+00:00

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

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
463 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,190 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,973 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,297 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 45,291 Reputation points
    2024-02-19T11:14:49.3266667+00:00

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.