topic Re: Can't achieve RLS using CustomData() in Power BI desktop embedded report using service principal in Report Server

Can't achieve RLS using CustomData() in Power BI desktop embedded report using service principal

evolveblurt — Fri, 24 Jun 2022 12:46:18 GMT

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.

Re: Can't achieve RLS using CustomData() in Power BI desktop embedded report using service principal

Anonymous — Mon, 27 Jun 2022 07:54:37 GMT

Hi evolveblurt ,

The CustomData feature allows you to add a Row filter by passing a free text (string) using the CustomData connection string property. Unlike users and roles, CustomData can't be set within a .pbix file.

Did you refer to this article and complete the preparation for custom data?

Using the CustomData feature

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Re: Can't achieve RLS using CustomData() in Power BI desktop embedded report using service principal

evolveblurt — Mon, 27 Jun 2022 08:42:00 GMT

Hello Caitlyn, thank you for your reply.

I'm affraid I didn't fully understand. I have followed the exact same steps as explained in the video, the RLS is indeed set at the .pbix level.

Are you suggesting using Analysis Services? Because if that is the case, that is what I want to avoid.

Re: Can't achieve RLS using CustomData() in Power BI desktop embedded report using service principal

evolveblurt — Mon, 04 Jul 2022 09:35:06 GMT

Hello everyone, it has been a week, I'm adding this comment to bump this thread. Anyone else can help?

Re: Can't achieve RLS using CustomData() in Power BI desktop embedded report using service principal

Anonymous — Mon, 04 Jul 2022 10:05:26 GMT

Hi evolveblurt ,

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

Best Regards,
Community Support Team _ Caitlyn

Re: Can't achieve RLS using CustomData() in Power BI desktop embedded report using service principal

evolveblurt — Mon, 04 Jul 2022 14:36:39 GMT

Thank you Cailtlyn!

Re: Can't achieve RLS using CustomData() in Power BI desktop embedded report using service principal

evolveblurt — Thu, 25 Aug 2022 12:46:23 GMT

Im bumping this thread again as some time has passed, I have talked to functional support and after they advising on requesting technical support, nobody has contacted me to help me with this.

Re: Can't achieve RLS using CustomData() in Power BI desktop embedded report using service principal

Anonymous — Mon, 07 Nov 2022 11:43:34 GMT

Hi evolveblurt , were you able to solve the issue?

Re: Can't achieve RLS using CustomData() in Power BI desktop embedded report using service principal

evolveblurt — Mon, 07 Nov 2022 11:57:54 GMT

Hello Pedro, unfortunately not. Can you help?

Re: Can't achieve RLS using CustomData() in Power BI desktop embedded report using service principal

evolveblurt — Mon, 07 Nov 2022 12:00:58 GMT

Anonymous do you have any news on this topic? I have contacted functional support but after they redirected me to technical support, nobody from the technical support has replied back.

Can you please redirect me to someone else who might be able to help?