Forum Discussion
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
This is TMSL, I am looking for XMLA
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.
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.