Forum Discussion
Dynamically generated date table using fiscal year start month in a multi-tenant dataset with RLS
- 6 years ago
Hi Anonymous ,
Based on my test, it is not available in Power BI. Your calculated fiscal table can't be changed by RLS.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Icey
I have a table that contains profile data (1 row for each customer) with things like name, id etc. Additionally, I have a column for fiscal year start month. There are hundreds of rows of data and each represents a customer in multi-tenant fact tables (the profile table is also used for row level security by associated a customer id in that table with customer id in the fact tables). There is a single row per customer in the profile table.
In my DAX formula for the date table, I am setting a variable similar to:
VAR fiscalstartmonth = profile[fy_startmonth]
I am expecting that only a single value should be returned since RLS should be limiting access to the data to a single row in the profile table. However, what I am seeing is that a list of values is being returned. The list is all the values for all the customers. A quick test using MAX(profile[fy_startmonth]) returns the highest value in the table (which is assigned to a different customer).
I was hoping that calculated tables were generated after the data was filtered by RLS. But it seems as though they are generated and then RLS is applied after the fact.
Hi Anonymous ,
Based on my test, it is not available in Power BI. Your calculated fiscal table can't be changed by RLS.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.