Forum Discussion
Is it possible to export Paginated Report from Logic App enforcing Row Level Security
Hello Sai,
Apologies for the delayed response. The above solution did not work. The following combination is not supported by Power BI:
Exporting Paginated Report with PBI Semantic Model enforcing RLS.
To implement RLS, we need to pass custom string in Effective Identity's username key. E.g "state" (If I want to restrict data only to particular state for the logged in person).
I get an error "User was not found in organisation.
Basically, the REST API endpoint goes to check for that user in the Azure AD.
But I have implemented RLS in an alternate way.
Thank you.
Hello,
I tried the above, but I get 403 error.
I authenticate using Service Principal and then pass the oAuth token as bearer token to get the Embed Token for the PBI.
While calling the GetToken PBI Rest API, I pass the required filters as username in the payload along with other required fields:
POST https://api.powerbi.com/v1.0/myorg/GenerateToken
{
"datasets": [
{
"id": "{dataset-guid}",
"xmlaPermissions": "ReadOnly"
}
],
"reports": [
{
"id": "{report-guid}"
}
],
"identities": [
{
"username": "84170958",
"datasets": [
"{dataset-guid}"
]
},
{
"username": "84170958",
"reports": [
"report-guid}"
]
}
]
}I get 403 in response.
Thank you
Community SupportHi bhavya11
Based on our previous conversation, if the solution I provided works for you, please don't hesitate to reach out if you have any further questions. If my response has resolved your query, kindly accept it as a solution and give it a 'Kudos' to help other members find it easily.
Thankyou.