cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Peter_MTG
Frequent Visitor

Powershell : Tabular Object Model, model object is null

I sometimes use PowerShell to quickly alter a set of similar measures in a Power BI dataset. This could be done with this code :

 

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices.Tabular")

$serverName = "localhost:xxxxx";
$databaseName = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx";
$svr = New-Object Microsoft.AnalysisServices.Tabular.Server
$svr.Connect($serverName)
$db = $svr.databases.GetByName($databaseName)

 

$findstring="find string"
$replacestring="replace string"

foreach($table in $db.Model.Tables) {
  foreach($measureobj in $table.measures) {
  $measureobj.expression=$measureobj.Expression.replace($findstring,$replacestring)
}
}

#$db.Model.SaveChanges()

 

Works great, until recently I found some reports where the Model-attribute of the database seems to be empty.

 

Peter_MTG_0-1685536489428.png

 

 Although it works perfectly fine in PowerBI, I can't find the model anymore in PowerShell. Also Tabular and DAX Studio are working fine with the reports dataset.

1 ACCEPTED SOLUTION
Peter_MTG
Frequent Visitor

I saw that in the report one of the datasources was still using the Power BI dataflows (Legacy) connector. As soon as I switched this one to the Power BI dataflows connector, the model attribute was correctly filled in.

 

I'm not 100 % using this connector always causes this problem, but at least in this case, replacing it solved the issue.

View solution in original post

1 REPLY 1
Peter_MTG
Frequent Visitor

I saw that in the report one of the datasources was still using the Power BI dataflows (Legacy) connector. As soon as I switched this one to the Power BI dataflows connector, the model attribute was correctly filled in.

 

I'm not 100 % using this connector always causes this problem, but at least in this case, replacing it solved the issue.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors