Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Xunh
Regular Visitor

Manipulating semantic models using AMO and TOM libraries

Hi,
my problem is the following. I have a report that should be consumed across countries, but having one large model plus row level security isn't really an option as report would be gargantuan in size.
So I'd like to try to manipulating model (it would be a really small change) and then deploy semantic models using XMLA endpoint.
I am using this C# code, 

using tab = Microsoft.AnalysisServices.Tabular;
using Azure.Identity;
using ac = Azure.Core;
using mas = Microsoft.AnalysisServices.Core;
using ma = Microsoft.AnalysisServices;
using Microsoft.AnalysisServices;





String tenantdId = "myTenantId";

String clientId = "myclientId";

String clientSecret = "myClientSecret"

tab.Server myServer = new tab.Server();
ClientSecretCredential clientSecretCredential = new ClientSecretCredential(tenantId, clientId,
clientSecret);

ac.AccessToken token = clientSecretCredential.GetToken(new ac.TokenRequestContext(new String[]
{ @"https://analysis.windows.net/powerbi/api/.default" }));
ma.AccessToken token1 = new ma.AccessToken(token.Token, token.ExpiresOn);
myServer.AccessToken = token1;
myServer.Connect(@"powerbi://api.powerbi.com/v1.0/myorg/<myWorkspace>");
tab.DatabaseCollection databaseCollection = myServer.Databases;
Console.WriteLine(databaseCollection.Count);
foreach (tab.Database item in databaseCollection) {
      tab.Model model = item.Model;
      if (model != null)
      {
            tab.TableCollection tabCol = model.Tables;
            foreach (tab.Table table in tabCol)
            {
                 Console.WriteLine(table.Name);
            }
      }
}



I am able to connect to server, see semantic model (database object) but although modelType property is Tabular, model property is always NULL, so I am not able to see actual tables and parameters.
My service principal in a member of workspace (not admin), semantic models readWriteMode is set to readWrite, default compatibilty is 1600.
I used the takeover REST API
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/take-over-in-group
to take over semantic model, and now it does belong to service principal I am using but nothing changed.
Semantic models were created alongside reports using Power BI desktop and then published to Power BI workspace assigned to premium capacity.
Is there anything that I am missing?

0 REPLIES 0

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.