Styjun

I'm feeling like my character doesn't fit the campaign

Would denouncing cheaters from an exam make me less likely to receive penalties?

How to use Adostop Eco stop bath?

Need a non-volatile memory IC with near unlimited read/write operations capability

Sense of humor in your sci-fi stories

Write a function

Is this really the Saturn V computer only, or are there other systems here as well?

Was it ever illegal to name a pig "Napoleon" in France?

Mtg creature spells, instants, priority?

Findminimum of Integral

Where are the Wazirs?

What is the relationship between external and internal composition in a cartesian closed category?

What was the profession 芸者 (female entertainer) called in Russia?

Category-theoretic treatment of diffs, patches and merging?

QR codes, do people use them?

Did depressed people far more accurately estimate how many monsters they killed in a video game?

Can the word "desk" be used as a verb?

How do I separate enchants from items?

Can Jimmy hang on his rope?

Strong Password Detection in Python

This LM317 diagram doesn't make any sense to me

How can I use my cell phone's light as a reading light?

How many Jimmys can fit?

How to evaluate the performance of open source solver?

Roles come back as null from Azure Analysis Services database when connecting using AMO in C#

What is the best way to obtain the complete list of permission of a given user using AMO in C#C# amo get roles completeTabular Analysis Service Azure connect and process via c#How can I return NULL from a generic method in C#?change the connection string values the app.configC# amo get roles completeDimensions atribute depending Locale IdentifierNot able to read connection string from app configIssues establishing a connection to Azure SQL Database using Connection string via a WCF ServicePassing some (any) kind of context info from SSAS connection string to underlying databaseAzure analysis service connection using Service principal not workingI created Analysis services databases by xmla scripts. But I can't show the values in table. e.g. run DAX 'evaluate table_name',there presents nothingUse Automation RunAs service principal to connect to Azure Analysis Services and process

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I have a tabular Azure Analysis Services database with compatibility level 1400. When I connect and try to retrieve the roles using the AMO package the Roles property is always null, the same for the DatabasePermissions property that is mentioned in this answer.

I am using the Tabular.Server and Tabular.Database objects as recommended in the official docs.

I have based my code off this answer and I am connecting using an administrator account.

Proof that roles are setup on the DB that I am accessing:

Inspecting the database object:

Interestingly enough I have two other databases inside the same Azure Analysis Services server and they have the same issue.

My code:

using (Server server = new Server())
 
 string serverDomain = "australiasoutheast.asazure.windows.net";
 string serverName = "redacteddevpilotv1";
 string databaseModel = "PilotV1";
 string serverAddress = $"asazure://serverDomain/serverName";
 //string token = await GetAccessToken($"https://serverDomain");
 //string connectionString = $"Provider=MSOLAP;Data Source=serverAddress;Initial Catalog=databaseModel;User ID=;Password=token;Persist Security Info=True;Impersonation Level=Impersonate";
 string connectionString = $"Provider=MSOLAP;Data Source=serverAddress;Initial Catalog=databaseModel;User ID=redacted;Password=redacted;Persist Security Info=True;Impersonation Level=Impersonate";

 var t = server.SupportedCompatibilityLevels;
 var x = server.Roles;

 server.Connect(connectionString);

 t = server.SupportedCompatibilityLevels;
 x = server.Roles;

 Database d = server.Databases.FindByName(databaseModel);
 

The documentation goes into how to add roles not how to retrieve them...

c# ssas roles ssas-tabular azure-analysis-services

share|improve this question

asked Mar 25 at 22:36

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges

add a comment | 

1

I have a tabular Azure Analysis Services database with compatibility level 1400. When I connect and try to retrieve the roles using the AMO package the Roles property is always null, the same for the DatabasePermissions property that is mentioned in this answer.

I am using the Tabular.Server and Tabular.Database objects as recommended in the official docs.

I have based my code off this answer and I am connecting using an administrator account.

Proof that roles are setup on the DB that I am accessing:

Inspecting the database object:

Interestingly enough I have two other databases inside the same Azure Analysis Services server and they have the same issue.

My code:

using (Server server = new Server())
 
 string serverDomain = "australiasoutheast.asazure.windows.net";
 string serverName = "redacteddevpilotv1";
 string databaseModel = "PilotV1";
 string serverAddress = $"asazure://serverDomain/serverName";
 //string token = await GetAccessToken($"https://serverDomain");
 //string connectionString = $"Provider=MSOLAP;Data Source=serverAddress;Initial Catalog=databaseModel;User ID=;Password=token;Persist Security Info=True;Impersonation Level=Impersonate";
 string connectionString = $"Provider=MSOLAP;Data Source=serverAddress;Initial Catalog=databaseModel;User ID=redacted;Password=redacted;Persist Security Info=True;Impersonation Level=Impersonate";

 var t = server.SupportedCompatibilityLevels;
 var x = server.Roles;

 server.Connect(connectionString);

 t = server.SupportedCompatibilityLevels;
 x = server.Roles;

 Database d = server.Databases.FindByName(databaseModel);
 

The documentation goes into how to add roles not how to retrieve them...

c# ssas roles ssas-tabular azure-analysis-services

share|improve this question

asked Mar 25 at 22:36

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges

add a comment | 

I have a tabular Azure Analysis Services database with compatibility level 1400. When I connect and try to retrieve the roles using the AMO package the Roles property is always null, the same for the DatabasePermissions property that is mentioned in this answer.

I am using the Tabular.Server and Tabular.Database objects as recommended in the official docs.

I have based my code off this answer and I am connecting using an administrator account.

Proof that roles are setup on the DB that I am accessing:

Inspecting the database object:

Interestingly enough I have two other databases inside the same Azure Analysis Services server and they have the same issue.

My code:

using (Server server = new Server())
 
 string serverDomain = "australiasoutheast.asazure.windows.net";
 string serverName = "redacteddevpilotv1";
 string databaseModel = "PilotV1";
 string serverAddress = $"asazure://serverDomain/serverName";
 //string token = await GetAccessToken($"https://serverDomain");
 //string connectionString = $"Provider=MSOLAP;Data Source=serverAddress;Initial Catalog=databaseModel;User ID=;Password=token;Persist Security Info=True;Impersonation Level=Impersonate";
 string connectionString = $"Provider=MSOLAP;Data Source=serverAddress;Initial Catalog=databaseModel;User ID=redacted;Password=redacted;Persist Security Info=True;Impersonation Level=Impersonate";

 var t = server.SupportedCompatibilityLevels;
 var x = server.Roles;

 server.Connect(connectionString);

 t = server.SupportedCompatibilityLevels;
 x = server.Roles;

 Database d = server.Databases.FindByName(databaseModel);
 

The documentation goes into how to add roles not how to retrieve them...

c# ssas roles ssas-tabular azure-analysis-services

share|improve this question

asked Mar 25 at 22:36

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges

using (Server server = new Server())
 
 string serverDomain = "australiasoutheast.asazure.windows.net";
 string serverName = "redacteddevpilotv1";
 string databaseModel = "PilotV1";
 string serverAddress = $"asazure://serverDomain/serverName";
 //string token = await GetAccessToken($"https://serverDomain");
 //string connectionString = $"Provider=MSOLAP;Data Source=serverAddress;Initial Catalog=databaseModel;User ID=;Password=token;Persist Security Info=True;Impersonation Level=Impersonate";
 string connectionString = $"Provider=MSOLAP;Data Source=serverAddress;Initial Catalog=databaseModel;User ID=redacted;Password=redacted;Persist Security Info=True;Impersonation Level=Impersonate";

 var t = server.SupportedCompatibilityLevels;
 var x = server.Roles;

 server.Connect(connectionString);

 t = server.SupportedCompatibilityLevels;
 x = server.Roles;

 Database d = server.Databases.FindByName(databaseModel);
 

share|improve this question

asked Mar 25 at 22:36

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges

share|improve this question

asked Mar 25 at 22:36

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges

asked Mar 25 at 22:36

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges

asked Mar 25 at 22:36

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges

1 Answer
1

active

oldest

votes

0

It turns out that instead of accessing roles through database.Roles I need to access them via database.Model.Roles. I'm not sure why this is or if it is documented anywhere but I was put onto this fact by another question.

After doing this I now have access to the ModelRole objects that I want.

share|improve this answer

edited Mar 26 at 2:00

answered Mar 25 at 22:58

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55347376%2froles-come-back-as-null-from-azure-analysis-services-database-when-connecting-us%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

It turns out that instead of accessing roles through database.Roles I need to access them via database.Model.Roles. I'm not sure why this is or if it is documented anywhere but I was put onto this fact by another question.

After doing this I now have access to the ModelRole objects that I want.

share|improve this answer

edited Mar 26 at 2:00

answered Mar 25 at 22:58

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges

add a comment | 

0

It turns out that instead of accessing roles through database.Roles I need to access them via database.Model.Roles. I'm not sure why this is or if it is documented anywhere but I was put onto this fact by another question.

After doing this I now have access to the ModelRole objects that I want.

share|improve this answer

edited Mar 26 at 2:00

answered Mar 25 at 22:58

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges

add a comment | 

It turns out that instead of accessing roles through database.Roles I need to access them via database.Model.Roles. I'm not sure why this is or if it is documented anywhere but I was put onto this fact by another question.

After doing this I now have access to the ModelRole objects that I want.

share|improve this answer

edited Mar 26 at 2:00

answered Mar 25 at 22:58

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges

share|improve this answer

edited Mar 26 at 2:00

answered Mar 25 at 22:58

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges

answered Mar 25 at 22:58

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges

answered Mar 25 at 22:58

Matt StannettMatt Stannett

1,43811 gold badge66 silver badges1919 bronze badges