Run Power BI Datasets XMLA Partitions in CLI

[kolturra]

Hi,

I have one dataset in which i have some 15 tables and each table has some 10 partitions.

Everyday i am running each table partitions manually by connecting to SSMS Analysis with XMLA Script. Is their any way i can connect it to CLI and run this parititions at one time.

When i say one code excution should take all the XMLA Script.

Thanks,

K Raghavender Rao

[lbendlin]

You can run XMLA scripts via PowerShell, for example.  Or ascmd. or a DDL in SSIS.

Invoke-ASCmd (SQLServer) | Microsoft Learn