Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Solved! Go to Solution.
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.
Proud to be a Super User!
Paul on Linkedin.
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.
Proud to be a Super User!
Paul on Linkedin.
Does your implementation allow for deployment pipelines? They claim to be solving your exact problem.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |