Forum Discussion
publish without access
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 π
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.
2 Replies
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.
Does your implementation allow for deployment pipelines? They claim to be solving your exact problem.
