Unable to browse Azure Analysis Services DB in Excel or SSMA

John Foster 0 Reputation points
2024-06-05T15:07:28.54+00:00

Hello Forum,

I have built a tabular cube in VS2022 (compatibility level 1500) which is using SQL Managed Instance as it's datasource in import mode. I have deployed this to Azure Analysis Services. I can connect to the DB in both Excel and SSMS and can see the model but I cannot see any of the tables to load or browse the data in Excel or SSMS. I can right click and process the db in SSMS and it says processed successfully but I still cannot browse. I had created an admin role containing myself in VS but I couldn't see the db in SSMS until I added myself as Analysis Service Admin in Azure. We use MFA for our Azure connectivity. Can anybody help me?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
456 questions
{count} votes

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.