Copy Paste Row-level security between PIBX

[Anonymous]

Hi guys,

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

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 !

[v-yingjl · Accepted solution]

Hi @Anonymous ,

Starting from September 2020 Update (2.85.284.0)  of power bi desktop ,Enhanced Dataset Metadata is now generally available,and is no longer a preview feature.

With the release of the enhanced dataset metadata feature, many of these limitations are removed. PBIX files are automatically upgraded to enhanced metadata upon opening the file. With enhanced dataset metadata, metadata created by Power BI Desktop uses a format similar to what is used for Analysis Services tabular models, based on the Tabular Object Model.

You can try to follow your posted blog to copy paste measures.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.