PowerBI report is built from multiple data source connection like SharePoint, third party application etx. PowerBI report is also configured with RLS for customer email id.
Dynamic Portal Power Pages:
Developed Customer self-service portal for customers where they can create, edit, and close cases. Customers are authenticated using third party Auth0 app in portal.
Requirement:
Embed PowerBI report in portal So that, when customer login (Customer who does not PowerBI or crm license) into portal, they should be able to view only records in PowerBI report related to their account.
We followed steps mentioned in below MS article:
https://learn.microsoft.com/en-us/power-pages/admin/set-up-power-bi-integration
https://learn.microsoft.com/en-us/power-pages/getting-started/add-power-bi
- But when we configure PowerBI report which is with RLS
we get error
“Liquid syntax error: A configuration error occurred while rendering your report.”
- And report without RLS, when we configure with Portal
we get below error:
When I try to embed PowerBI in portal using “Embed with your Organization” ie AD, then Report is displayed in correct format.
POC:
We created a new PowerBI dataset and report in PowerBI Desktop application which contains information like amount and emailid .
Report in PowerBi looks like below:
We have also configured RLS in report:
When we embed that report in Portal it works as expected for portal logged in users.
But same process does not work for my client’s report.
Please help