Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have a report in power bi embedded that had been working ok for months. It uses rls for security on custmers information. For this, it uses a dax formula to apply on a table :
[ML_Id_CodeKey] IN SELECTCOLUMNS(
FILTER(
'Fact_RelCustomerLab',
RELATED(Dim_CustomerLog[CL_Id_CodeLog])=CONVERT(USERPRINCIPALNAME(),INTEGER)
),"ML_Id_CodeKey",
'Dim_LABS'[ML_Id_CodeKey]
)
I needed to filter DIM_LABS and the direction of the relationship was the opposite, so I needed the formula. This formula was working just fine but since this morning is not working anymore in power bi embedded, but it's still working on Desktop.
Has been any updates recently that may have affected to this behaviour?
I have other reports that uses the typical [customer]=USERPRINCIPALNAME() and they still work ok.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @mvarela @belvoir99
Based on your discussion, it seems that some updates on Service caused this kind of issue. Sometimes the update will bring some compatibility issues. Have you ever tried to update the RLS to original Dax formula with October updated Desktop and then override the report in Service?
Best Regards,
Community Support Team _Caiyun Zheng