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
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;
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
asked Mar 25 at 22:36
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 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
asked Mar 25 at 22:36
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 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
asked Mar 25 at 22:36
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 bronze badges
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
c# ssas roles ssas-tabular azure-analysis-services
asked Mar 25 at 22:36
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 bronze badges
asked Mar 25 at 22:36
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 bronze badges
asked Mar 25 at 22:36
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 bronze badges
asked Mar 25 at 22:36
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 bronze badges
asked Mar 25 at 22:36
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 bronze badges
1,4381 gold badge6 silver badges19 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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.
answered Mar 25 at 22:58
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 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
);
);
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
answered Mar 25 at 22:58
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 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.
answered Mar 25 at 22:58
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 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.
answered Mar 25 at 22:58
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 bronze badges
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.
answered Mar 25 at 22:58
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 bronze badges
edited Mar 26 at 2:00
answered Mar 25 at 22:58
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 bronze badges
answered Mar 25 at 22:58
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 bronze badges
answered Mar 25 at 22:58
Matt StannettMatt Stannett
1,4381 gold badge6 silver badges19 bronze badges
1,4381 gold badge6 silver badges19 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
