Unable to download Tabular Model from Azure Analysis Services using Visual Studio / SSMS

Pradnyesh Patil 0 Reputation points
2026-04-03T07:33:53.5233333+00:00

Issue Description:

We are attempting to download the model using Visual Studio (Analysis Services Tabular Project) by selecting Import from Server (Tabular Model) and connecting to the Azure Analysis Services instance. However, the download process fails with an error and the model cannot be retrieved locally.

We also attempted connecting through SQL Server Management Studio (SSMS) but encountered similar issues when trying to access or export the model.

Questions:

  • Is there a specific permission required to download a model from Azure Analysis Services?
  • Are there any known limitations when downloading models from Azure Analysis Services using Visual Studio?
  • Is there an alternative method to export or download the model (for example using Tabular Editor or scripting)?

Any guidance on how to successfully download the model would be appreciated.

Azure Analysis Services
0 comments

2 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-04-03T07:34:10.29+00:00

    To download or redeploy a tabular model from Azure Analysis Services, the following points apply based on the available information.

    • Permissions:
      • The account must be in the Analysis Services Admins group on the Azure Analysis Services server to fully manage and script databases, including connecting from Visual Studio and SQL Server Management Studio (SSMS).
      • In SSMS, connection requires that the username is included in the Analysis Services Admins group before first connection.
    • Using Visual Studio (Analysis Services Tabular Project):
      • Install Visual Studio plus the Analysis Services projects extension, which provides the tabular project templates and designers.
      • In Visual Studio, tabular and multidimensional model projects are created and deployed using these templates; they can also connect to Azure Analysis Services servers.
      • To deploy (and thus round‑trip models), set the Deployment Server property to the Azure Analysis Services server name (from Azure portal → server → Overview → Server name) and use Deploy from Solution Explorer. If deployment fails, verify:
        • Visual Studio can connect to the server (test with SSMS first).
        • The Deployment Server property is correct.
        • Data source connectivity (for table processing) is working; for on‑premises sources, an On-premises data gateway may be required.
    • Using SQL Server Management Studio (SSMS):
      • Ensure the latest SSMS version is installed for best compatibility with Azure Analysis Services.
      • Connect via Connect → Analysis Services, paste the server name from the Azure portal, and use an appropriate authentication type (for example, Active Directory – Universal with MFA support is recommended).
      • Once connected, SSMS can manage servers and model databases, run TMSL scripts, and work with deployed models.
    • Alternative/advanced methods (scripting and object model):
      • The Tabular Object Model (TOM) is a C# library for creating and managing tabular models and databases in managed code for Azure Analysis Services and SQL Server Analysis Services. It can be used to script out and automate model management operations against a server.
      • The SQL Server Analysis Services Deployment Wizard (installed with SSMS) works with JSON output files generated from an Analysis Services project. It can generate deployment scripts and automate deployment or synchronization between servers. For large databases, partitions and TMSL/TOM/AMO automation are recommended.

    Within the provided information, Visual Studio with the Analysis Services projects extension and SSMS (with appropriate admin permissions) are the primary supported tools for working with Azure Analysis Services models. TOM, TMSL, and the Deployment Wizard provide script‑based and automated alternatives for managing and redeploying models.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Pilladi Padma Sai Manisha 11,715 Reputation points Microsoft External Staff Moderator
    2026-04-03T22:26:47.19+00:00

    Hi Pradnyesh Patil,
    it sounds like you’re able to connect to your Azure Analysis Services (AAS) instance but can’t pull down the model definition (Model.bim) into Visual Studio or SSMS. Let’s walk through the usual blockers and some workarounds:

    1. Permissions you need
      • To import or “download” a Tabular model you must be in one of two roles on the AAS server: • Server Administrator (at the Azure resource‐level or via the AAS server-admin role) • Or a Database Administrator role for that particular model database
      • If you only have read/query permissions (e.g. a “read” database role), Visual Studio/SSMS will let you connect but won’t let you pull down the full model definition.
      • In the Azure portal you can add your user under “Server Admins” (or use Azure RBAC to give the Azure Analysis Services Reader role plus the server-admin role).
    2. Known VS/SSMS limitations & gotchas
      • Visual Studio: make sure you’re on VS2017/2019/2022 and have the latest Analysis Services Projects extension installed (Extensions → Manage Extensions → Updates). Older client libraries can fail with obscure AADSTS or metadata errors.
      • The Import-From-Server template only works if the model’s compatibility level is ≥ 1200. Very old models (1100 or lower) must be upgraded first.
      • SSMS: you can connect to AAS, but SSMS doesn’t have a “Download Model” wizard. You can script objects out one at a time, but you won’t get the full Model.bim in one go.
    3. Alternative ways to get the model locally • Backup + Restore – In SSMS, right-click your AAS database → Backup… → give an Azure Blob Storage container → run the backup. – Then restore that backup to a local SQL Server Analysis Services instance to get a working .abf file. • XMLA / TMSL scripting – In SSMS object explorer, right-click the database → Script Database As → CREATE To → File. You’ll get an XMLA script you can keep in source control. • Tabular Object Model (TOM) or PowerShell – Use the Az.AnalysisServices or SqlServer PowerShell modules to Connect-AnalysisServicesServer and then call the TOM API to save out the Model.bim. • Tabular Editor (v2 or v3) – Connect directly to your AAS server via the XMLA endpoint, then do File → Save As → Model.bim or export to JSON.

    If you’re still hitting a specific error when you do Import-From-Server, let us know:

    • Exact error text or screenshot
    • Your VS version + Analysis Services Projects extension version
    • Model compatibility level in AAS
    • Your AAD sign-in method

    That info will help zero in on any lingering client-library or authentication problems.

    — Reference docs

    1. Deploy a model from Visual Studio (also covers importing) https://learn.microsoft.com/azure/analysis-services/analysis-services-deploy
    2. Deploy from Visual Studio (detailed tabular-specific) https://learn.microsoft.com/analysis-services/deployment/deploy-from-visual-studio-tabular
    3. Server and database roles for AAS security https://learn.microsoft.com/azure/analysis-services/analysis-services-server-admins https://learn.microsoft.com/azure/analysis-services/analysis-services-database-users
    4. Troubleshooting VS extension updates https://learn.microsoft.com/analysis-services/deployment/deploy-from-visual-studio-tabular#update-to-the-latest-visual-studio-extension
    5. SSMS scripting & XMLA https://learn.microsoft.com/analysis-services/tom/introduction-to-the-tabular-object-model-tom-in-analysis-services-amo

    Hope that helps! Let me know the details of any error messages if you need more help.

    Note: This content was drafted with the help of an AI system. Please verify the information before relying on it for decision-making.

    Was this answer helpful?

Your answer

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