Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have managed to create a new semantic model using XMLA Endpoint and C# but now I need to be able to create Roles for RLS using the same method. Is this allowed? And if so How can I go about doing it?
Below is my simple code in creating the semantic model.
If I can call a REST API tha twould work too... I just didn't see any that would work.
string newDatabaseName = server.Databases.GetNewName(DatabaseName);
var database = new Microsoft.AnalysisServices.Database()
{
Name = newDatabaseName,
ID = newDatabaseName,
CompatibilityLevel = 1520,
StorageEngineUsed = Microsoft.AnalysisServices.StorageEngineUsed.TabularMetadata,
Model = new Model()
{
Name = DatabaseName + "-Model",
Description = "A Demo Tabular data model with 1520 compatibility level."
}
};
server.Databases.Add(database);
database.Update(Microsoft.AnalysisServices.UpdateOptions.ExpandFull);
Solved! Go to Solution.
Hi @Clampazzo
What I would do is to connect to the XMLA endpoint using tablet editor and create the roles using tabler editor. It would be a lot quicker and efficiently create your role and give them as working as expected.
Thanks for the reply @GilbertQ , while that would be easy to do I need to dynamically create these datasets. They will all be DirectQuery but I am creating a new dataset (sometimes multiple) per client workspace. So going in manually later would be difficult to do.
If there's a way to copy a template dataset and then modify it using xmla (while keeping roles) that would be acceptable too.
Hi @Clampazzo
One option might be to script after the database after you have created the roles. You can then use this script to reapply to other app workspaces with the roles as part of the script.
That sounds like a possibl workaround... is there any documentation on how to do that?
I'm accepting as solution but I may ping back if I have more questions. Thanks for your help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.