Power BI - Copy Paste Row-level security between PIBX files

1.5k views Asked by At

As said in the title, I would like to copy paste the RLS done in the PIBX A to the PIBX B.

I have done much research on google and I found out a solution using the template but these 2 PIBX has been developed so I can not generate a template from A to start the development of B

I tried the Tabular Editor integrated in Power BI as External Tool too but when I do copy paste, it says that the Role TEST1_PRIX5 (from PIBX A to copy) points to the table which doesn't exist. The table 'Feuil1' exists in both PIBX enter image description here

I found this one here https://exceleratorbi.com.au/copy-measures-between-2-power-bi-files/. It shows how to copy paste measures and I try to do the same with RLS. The first step is to stick the option : "Store datasets using enhanced metadata format". I don't have this option in my PWBI Desktop, do you think the problem is here ?

Thank you in advance !

1

There are 1 answers

0
javadoe On

In Tabular Editor you have to enable experimental Power BI features in "File > Preferences" to be able to copy the roles without this error:

File > Preferences > Features > Allow unsupported Power BI features (experimental)

Make sure you save the changes back to the .pbix file and double check in "Manage Roles" in Power BI whether or not the roles came in. It worked for me this way.