Forum Discussion

vickyd's avatar
vickyd
Helper V
8 years ago
Solved

Publishing process to PBI Report Server

When one deploys a SSRS report using Visual Studio, there is an option to not deploy the data sources. So we can setup the data sources once in the Report Server in each environment (Development/UAT/Production) and deploy and not have to worry about the report pointing to the wrong database on deployment. 

 

With PBI Desktop, there is only a Save As option and no publish or deploy option to Report Server so every time a report is saved to a server, the data source connection also gets overwritten with whatever you had connected to in PBI Desktop. 

 

Is there any way this can managed better or is it just how PBI Desktop will be and we have to live with it? 

4 Replies