Forum Discussion

smpa01's avatar
smpa01
Community Champion
1 year ago

TMSL equivalent in XMLA

Does XMLA has an equivalent of TMSL's createOrReplace?   I tried with Alter Element but it did not work.   bcdobbs  GilbertQ 
Need Help
lbendlin's avatar
lbendlin
Super User
1 year ago

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's avatar
    smpa01
    Community Champion
    1 year ago

    This is TMSL, I am looking for XMLA

     

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      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's avatar
        smpa01
        Community Champion
        1 year ago

        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.