What is the best way to generate and deploy Power BI datasets? XMLA Endpoints?

[Anonymous]

We are currently using Vertipaq/DAX within SSAS Tabular.

We do generate our (complex) cubes through Powershell using some requirements held in a JSON definition of our own making.
We do this by modifying a base model created using Visual Studio and "exported" to an XMLA format.
The XMLA is modified by Powershell and the cube is then deployed to SSAS using the resulting XMLA.

We are planning to move our cubes to Power BI Datasets and thinking of using the same XMLA based approach, still holding our initial model in Visual Studio.
Then we'd deploy using the Power BI XMLA Endpoint.

Does it sound as a reasonable approach with Power BI?

We know about Power BI (Desktop) Templates but they do not seem like an appropriate route if we want to automatically modify them before deployment...

Thanks

[Anonymous]

Thanks

[Anonymous · Accepted solution]

Hi  @Anonymous ,

This is the related document, you can view this content:

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-connect-tools

https://docs.microsoft.com/en-us/power-bi/admin/troubleshoot-xmla-endpoint

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.