Forum Discussion
Changing Connection String with Import Mode
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
3 Replies
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?
Options:
- Use a query parameter in your Source step
- Use Advanced Editor to change your Source line
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
