Exception when referencing SSAS Tabular model in C#

Question

I am attempting to automate partition refreshes in Azure Analysis Services via C#. I have installed and referenced the latest 'Microsoft.AnalysisServices. ..' assemblies found here:

https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers.

I then have the following code:

using System; using Microsoft.AnalysisServices.Tabular;

    public void Run()
    {
        Server asSrv = new Server();

        try
        {

            asSrv.Connect(ASConnectionString);
            Database db = asSrv.Databases.FindByName("HospoIQTabular");
            Model m = db.Model;

            // only refresh 2017 partitions

            m.Tables["Sales"].Partitions["Sales - Post 2017"].RequestRefresh(RefreshType.Full);
            m.Tables["Payments"].Partitions["Payments - Post 2017"].RequestRefresh(RefreshType.Full);

            db.Model.SaveChanges();     // commit which will execute the refresh

        }
        catch (Exception e)
        {
            OnEventLog(e.Message);
        }
        finally
        {
            asSrv.Disconnect();
            asSrv = null;
        }

    }

Connect to the server and database itself works fine. However, attempting to reference 'db.Model' throws the following exception:

The value '2' is unexpected for type 'DataSourceType'.

I've looked but can't find any help anywhere on this. Any thoughts??

I've figured it out. Need to use the assemblies directly from here: C:\Program Files\Microsoft SQL Server\140\SDK\Assemblies. Not the 130 versions as indicated in some blogs online. — Andrae Gaeth, Jun 01 '17 at 03:35
your comment helped me, could you post it as answer to this question? — arghtype, Sep 08 '17 at 23:05

score 2 · Answer 1 · edited Nov 22 '19 at 21:50

2

The problem is similar with the NuGet package Microsoft.AnalysisServices.Tabular (v13)

Fortunately you can use the NuGet packages listed here: https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers.

In Visual Studio NuGet lists this package as Microsoft.AnalysisServices.retail.amd64

edited Nov 22 '19 at 21:50

degathem

5
4

answered Aug 14 '18 at 15:00

Softcadbury

33
6

score 1 · Answer 2 · edited Jan 05 '18 at 21:31

1

For me, the path that worked was C:\Program Files (x86)\Microsoft SQL Server\140\SDK\Assemblies but only after reading Andrae comment which sent me on the right direction

edited Jan 05 '18 at 21:31

Brandon Minnick

13,342
15
65
123

answered Jan 05 '18 at 21:07

Lior

41
1

I couldn't relate with the path. What should I change in the path? Can you be more concrete about this answer. – SillyPerson Mar 07 '18 at 08:11
Hi. Can you share what path you attempt to use atm? thanks – Lior May 29 '18 at 19:09

Exception when referencing SSAS Tabular model in C#

2 Answers2

Linked