RLS Issue in Embedded Report, but there's no RLS applied

[jnguyen]

Hoping ya'll can help. I'm running into an error message when attempting to embed my PowerBI Report. I don't have RLS enabeled but am receiving the following error:

Thanks!

[ragavanrajan]

Hi @jnguyen , 

On the first instance, I am adding the official link to enable power BI 

https://docs.microsoft.com/en-nz/powerapps/maker/portals/admin/set-up-power-bi-integration 

if you face any issue then please follow the additional steps described below. 

You need to enable the following permissions for your PowerApps portal in Azure App Registration. Here are the steps for you. 

In PowerApps: 

1. Log in to https://make.powerapps.com/ and make sure you are in the right environment 

2. Apps > Select your App> Settings > Administration and copy the application id 

In Azure portal: 

1. Login to https://portal.azure.com/#home 

2.  Search for App Registration > All applications > paste the application id 

3.  It will show you the app with the name "CRM Portal" 

4. Select API permissions > And enable the following permission 

Hope it helps. 

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[jnguyen]

Hey @ragavanrajan i appreciate the detailed write-up. I verified your steps have already been completed but I'm still running into the same error.

[ragavanrajan]

Hi @jnguyen , If you have enabled all settings mentioned above. It is most likely because of the workspace which is not refreshed. As per the official link which I posted. Could you remove all your workspace and apply. Then Edit the portal and press the sync configuration one time. Then in the portal could you put it back your workspace and try again. 

Let me know if that helps .

[jnguyen]

Hey @ragavanrajan  I had a global admin help me do this step, and it is still not working. I'm not understanding why this error is here when there is no RLS set up on the report. 

[ragavanrajan]

Hi @jnguyen , 

I have tested the sample No Row Level Security Power BI report with the Access Type of "Embed for your organization" 

and I could see the report in the page. 

Hope it helps

[jnguyen]

Hey the report we are embedded is using a live connection to AAS, and will need to be for external users. I've exhausted my resources and when ahead and opened a ticket with microsoft. Thank you for your efforts @ragavanrajan