Forum Discussion

markbrod's avatar
markbrod
Frequent Visitor
6 years ago

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 o...
connectionstring
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

markbrod 

Options:

  • Use a query parameter in your Source step
  • Use Advanced Editor to change your Source line
markbrod's avatar
markbrod
Frequent Visitor
6 years ago

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