Can't achieve RLS using CustomData() in Power BI desktop embedded report using service principal
Hello, I have found this article The CustomData feature is now generally available in Power BI! | Microsoft Power BI Blog | Microsoft Power BI and this video https://youtu.be/iBGEKKelgpA?t=2658. However, I am unable to reproduce the same results. I have performed the following steps: 1. I am using the same resources at GitHub - PowerBiDevCamp/RowLevelSecurity: Demo files from the Power BI Dev Camp session on Row Level Security. 2. I have uploaded the report (...)\RowLevelSecurity-main\PBIX\Wingtip Sales RLS with CustomData.pbix since its the one with the same table structure as used in the video. There is another one at (...)\RowLevelSecurity-main\RowLevelSecurityWithCustomData\RowLevelSecurityWithCustomData.pbix but different table structure, to my default workspace in https://app.powerbi.com/ 3. I have updated the (...)\RowLevelSecurity-main-v2\RowLevelSecurity-main\RowLevelSecurityWithCustomData\RowLevelSecurityWithCustomData\appsettings.json with the TenantId, ClientId, ClientSecret, WorkspaceId and CustomDataReportId and started the solution in debug mode. I have noticed it is not https, but the page loads, however no report is displayed. This is how the report displays in https://app.powerbi.com/ This is how it is displayed for User 1 (default) This is how it is displayed for user 2 I have found the syntax for ContainsString here CONTAINSSTRING – DAX Guide is different from the one used in the video (ContainsString(CustomData(), [State]), however, I have tried switching it up but to no avail. Can someone please help? Thank you for your time, let me know if you need more information.
