topic Re: Changing Connection String with Import Mode in Report Server

Changing Connection String with Import Mode

markbrod — Thu, 23 Jul 2020 17:17:16 GMT

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

Re: Changing Connection String with Import Mode

Greg_Deckler — Thu, 23 Jul 2020 17:24:43 GMT

markbrod

Options:

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

Re: Changing Connection String with Import Mode

markbrod — Thu, 23 Jul 2020 20:57:00 GMT

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

Re: Changing Connection String with Import Mode

winceeS — Tue, 21 Jun 2022 11:53:40 GMT

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?