TMSL equivalent in XMLA

[smpa01]

Does XMLA has an equivalent of TMSL's createOrReplace?

I tried with Alter Element but it did not work.

@bcdobbs  @GilbertQ 

[GilbertQ]

Hi @smpa01 

As @lbendlin said there is no XML format for the Semantic Models. They are stored in JSON or if using the newer format will now be TMSL.

[GilbertQ]

If you script it out from SSMS it will be in the XML structure?

[smpa01]

ssms does not have any ALTER to script that is equivalent to TMSL's createOrReplace.

[lbendlin]

Please check further back in the thread. I provided just such an example. I selected an object and clicked the Script button.

[smpa01]

That is not my requirement and lets not turn this into a XY problem.

[lbendlin]

No, that produces JSON. However that works well enough, so I don't really see the need to insist on XML.

[lbendlin]

seems to be the same syntax.

{
  "createOrReplace": {
    "object": {
      "database": "Opportunity Field History",
      "table": "Opportunities",
      "partition": "2014"
    },
    "partition": {
      "name": "2014",
      "mode": "import",
      "source": {
        "type": "policyRange",
        "start": "2014-01-01T00:00:00",
        "end": "2015-01-01T00:00:00",
        "granularity": "year"
      }
    }
  }
}

[smpa01]

This is TMSL, I am looking for XMLA

[lbendlin]

I thought so too but you can use that as is in your XMLA calls.

Login-PowerBI
$XmlaQuery = @"
{
"refresh": {
"type": "automatic",
"applyRefreshPolicy": true,
"effectiveDate": "1/1/2024",
"objects": [
{
"database": "Analyze in Excel",
"table": "Details"
}
]
}
}
"@

# URL is a relative or absolute URL of the Power BI entity to access. 
$res=Invoke-PowerBIRestMethod -Url 'groups/xxx/datasets/yyy/refreshes' -Method Post -Body $XmlaQuery 

etc.

[smpa01]

Thanks but I am looking for the XML structured query for xmla and not json structured query. Currently pq formatting in json structure is a pure nightmare (bism normalizer) , I need to see how the same appears in xml structure.