Deploy Power BI reports programatically with different SSAS connections per tenant

Hi v-henryk-mstf ,

thank you for your input and sorry for my late response.

The provided article is a great source for PowerBI related solutions for pbix files containing the data and its model.

What we need, is a way to connect a given report to an Azure Analysis Service and deploy the report to a given workspace. This aspect is not handled by the John Miners article.

We tried to manipulate the pbix file in regards to its datasource connection, but since we could not refresh the required checksum within the document, we were not able to deploy the report after altering the document.

Our reports use SSAS with live connections (we don't import the data into the pbix file).

All measures are defined within SSAS, not inside the pbix.

We cannot use variables since this feature is not available once connected to an Analysis Service.

We have:

- 1 SSAS for QA (pre production)

- 1 SSAS for PROD

- a  pair of workspaces per customer for QA and PROD

- 30+ customers

If we want to deploy a new version of a give report to all customers, we need to manually open the report in powerbi desktop, select the customers ssas datasource and the QA workspace for that customer and publish the report 

Then we have to repeat this step for the next 30 customers one by one.

The goal is to have 1 report for all customers and only change datasource and workspace without manual steps in between.

Please let me know, if you need more input.

Kind regards,

Michael