Powerbi Reports using SPN
Hi there, I'm trying to report on all workspace's, DataSets associated to a datasource in our tenant. We setup an spn with Tenant.Read.All delegated api permissions. The Allow service principals to use Power BI APIs is enabled for the security group that the app is a member of.Created a client secret as well as certificate.We are able to connect using Connect-PowerBIServiceAccount to 'however no data is returned. When connecting using my account, i'm able to output the workspace that my account is a member of. So i'm not sure if im missing other permissions to the workspaces.
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.
