publish without access

[Wolfiz]

Good afternoon,

Our developers create some nice report with PBI but the problem is they use a database X.  Those database (X) contains only Development data.

Once they want to publish it, we must first adapt their report to use the database Y which content Production data.

Is there a way for the developers to publish their report updating the database from X to Y , BUT NOT ADDING THE CREDENTIALS ?

By this way, their report will be refreshed through the Gateway (user can select the connection in the gateway) which will be setup to use the UID/PWD link to the DB Y (where the user cannot have access)

Thanks 🙂

[PaulDBrown · Accepted solution]

@Wolfiz 

The developers can save the report as a template (choose the option ins save as in desktop). Then use the template file, change the data source to database y and publish the new pbix file. 

[lbendlin]

Does your implementation allow for deployment pipelines?  They claim to be solving your exact problem.