Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
456 questions
Unable to browse Azure Analysis Services DB in Excel or SSMA
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
John Foster
0
Reputation points
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?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 31,116 Reputation points Microsoft Employee2024-06-05T19:05:47.3566667+00:00 Hello John Foster,
Welcome to the Microsoft Q&A forum.
A similar issue has been discussed on the below stackoverflow thread.
Can you open SSMS using 'Run As Administrator' and see if you are able to see the databases?
-
John Foster 0 Reputation points
2024-06-06T06:10:05.9566667+00:00 Hi BhargavaGunnam-MSFT
I did try opening SSMS as administrator but still same issue - I can connect to the server and see the db but I cannot see any tables, measures or attributes. It even let's me process the db but still no objects are visible to browse.
-
Bhargava-MSFT 31,116 Reputation points Microsoft Employee
2024-06-06T18:56:50.8066667+00:00 Hello John Foster,
I tried to repro the issue using the compatibility level 1500. However I am able to see the tables using SSMS. The issue could be due to permissions, or a connectivity issue related to MFA/Network.
Can you please rule out these?
-
John Foster 0 Reputation points
2024-06-07T09:30:28.84+00:00 Hi BhargavaGunnam-MSFT
I have raised this with our infrastructure team and am waiting for their response. Hopefully they will just need to change some config. I'll update this comment once I get a response.
-
Bhargava-MSFT 31,116 Reputation points Microsoft Employee
2024-06-07T15:10:45.2366667+00:00 Sure, John Foster
Thank you. Once you find a solution, please update us here, as it helps the community find answers to similar questions.
Sign in to comment
Sign in to answer