Forum Discussion
Promoting reports from UAT to Production and RLS setup
Hi DataWiz99,
>>I'm looking for a way to duplicate the entire environment, or suggestions on promoting reports between environments and how to tackle RLS setup in new environments.
As you said, current power bi not contains features to auto convert and publish report to different environment, you need to manually re-publish same report with different connection on different environment.
I'd like to suggest you save report as template, then you only need to change connection string and publish it.
For security setting, if each environments/data source has same structure, you can try to use RLS with USERNAME to achieve dynamic RLS.
Regards,
Xiaoxin Sheng
Hi DataWiz99,
>>I'm looking for a way to duplicate the entire environment, or suggestions on promoting reports between environments and how to tackle RLS setup in new environments.
As you said, current power bi not contains features to auto convert and publish report to different environment, you need to manually re-publish same report with different connection on different environment.
I'd like to suggest you save report as template, then you only need to change connection string and publish it.
For security setting, if each environments/data source has same structure, you can try to use RLS with USERNAME to achieve dynamic RLS.
Regards,
Xiaoxin Sheng
Hi Anonymous,
Thank you for the response, Yes I chose to go the Template route as it makes promoting reports simpler.
