Modify RLS Once Published - Incremental Refresh Model

[debenaire]

Hi All,##Bit of a tricky one. Have an exisitng report in service. Very large dataset so don't really want to be republishing the report. Have an optimised RLS approahc using enhanced DAX and want to deploy this. I had two thoughts, one vieiwng the model in service, which i understand you can't with an inremental refresh model. 2. using an external tool like ALM toolkit / tabular editor. ALM doesnt seem to have the facility and neither does my version of tabular editor. Is it possble to remove incremental refresh and deply using ALM toolkit, change the RLS then change the policy back without losing partitions etc? Any other suggestions welcome. Thanks.

[GilbertQ · Accepted solution]

Hi @debenaire 

You could just deploy your RLS changes to your dataset if you can connect via ALM Toolkit?

Just make sure to change the options in the ALM Toolkit as shown below.

[debenaire]

Worked a dream, thanks so much!!