Changing Connection String with Import Mode

[markbrod]

I have 20 or so Power BI Report Server reports all using ImportMode with SSAS(MD).

I need to publish these to 6 different environments(all with different connection string’s)

Looking for a couple of things

1)When will the ability to programmatically change the connection string for Import Mode, allowing for Data Refresh, be available.

I realize  you can do this for Direct Live but I need Import Mode

https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-source-apis

2)Until this ability exits what are potential work arounds…manually deploying 20 reports to six different environments is not that appealing to me.

Thanks

Mark Brodie

[winceeS]

@markbrod , I wonder if you have a work around now or a fix for this issue. We have the same setup, also deploying reports through git that uses REST APIs. Have you found a way to deploy and update the datasource of a power bi import mode report without opening the file itself and adding the parameters?

[Greg_Deckler]

@markbrod 

Options:

• Use a query parameter in your Source step
• Use Advanced Editor to change your Source line

[markbrod]

Thanks for the response....

We did look into doing this and that works fine but it still requires me to go in the Power BI Desktop open the report and change the parameter value.
We already have a deployment pipeline with SSSR and I want to do the same with PBIRS using the PBIRS  Restful API.
So what I want is during the  deployment process to have the ability to change the connection string.
I really don't want to first go into every report in the Power BI Desktop and change the connection through a Parameter.

Mark