Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
DataWiz99
Frequent Visitor

Promoting reports from UAT to Production and RLS setup

Hi, 

 

We are currently evaluating PowerBI as a reporting tool for one of our Customer Facing application and  I ran into an issue related to deployment. Currently, I'm developing all my reports using PowerBI Desktop and publishing them to PowerBI service (we have multiple workspaces - Grouping of reports and access control through workspaces). However,  I did not find any direct option to transfer all my Dev reports to UAT and then to Production. I even parameterized Connection string, schema name but in order to promote a report, I still need to manually make a copy of reports from dev environment then open the report in the new environment using powerbi desktop and make the changes to the parameters and refresh and publish each report separately.

 

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.

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

RLS with UserName()

 

Regards,

Xiaoxin Sheng

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

RLS with UserName()

 

Regards,

Xiaoxin Sheng

Hi @Anonymous, 

 

Thank you for the response, Yes I chose to go the Template route as it makes promoting reports simpler. 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.