Forum Discussion
RLS with Power BI Embedded and SSAS Multidimensional
Found the solution by myself at last...
If someone else is intrerested:
Setup a role in the Multidimensional database in SSAS. Choose 'Read definition' and 'Read' access on the cube of interest. Under dimension data chose the CUBE DIMENSION which you want to filter on. Pick the attribute of interest and under 'Advanced' and 'Allowed member set': type the following expression:
STRTOMEMBER('[Organization].[Organization Id].&[{'+CUSTOMDATA()+'}]')
and of course replace Organization and Organization Id with your dimension attributes.
And chose Enable Visual Totals if you don't want each organization to know the total in the measures.
Found the solution by myself at last...
If someone else is intrerested:
Setup a role in the Multidimensional database in SSAS. Choose 'Read definition' and 'Read' access on the cube of interest. Under dimension data chose the CUBE DIMENSION which you want to filter on. Pick the attribute of interest and under 'Advanced' and 'Allowed member set': type the following expression:
STRTOMEMBER('[Organization].[Organization Id].&[{'+CUSTOMDATA()+'}]')
and of course replace Organization and Organization Id with your dimension attributes.
And chose Enable Visual Totals if you don't want each organization to know the total in the measures.