User Profile
poweruser1
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Create partition via powershell error
I am trying to write a Powershell script to create a partition in a Power BI dataset. Anyone know how to resolve this error? I am receiving the following error: My Powershell Code: $m_code = "let Source = Sql.Database(`"source`", `"db`", [Query=`"sel column form table`", CommandTimeout=#duration(0, 1, 0, 0)]) in Source" $tmsl = "{ `"create`": { `"parentObject`": { `"database`": `"model name`", `"table`": `"Table name`" }, `"partition`": { `"name`": `"test partition`", `"source`": { `"type`": `"m`", `"expression`": [ `"$m_code`" ] } } } }" invoke-ascmd -Server "powerbi://api.powerbi.com/v1.0/myorg/workspace" -Database "model Name" -Query $tmsl
