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
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.