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.
Community SupportHi bhavya11
Thanks for posting in Microsoft Forum community.
Regarding your query, you can indeed export a Paginated Report from Logic App while enforcing Row Level Security. Here are some steps and considerations that could assist you in addressing this issue:
- Make sure that the username you're passing in the token is in the correct format and exists in your organization. The username should match the format expected by your Azure Active Directory (AAD) and also verify that the user has the necessary permissions to access the report and the data. The user should have appropriate roles assigned in both Power BI and AAD.
- Double-check the process of generating the token. Ensure that the token includes the necessary claims and is generated correctly using the Generate Token REST API endpoint Also, make sure that the token is valid and not expired.
- And ensure that the Identity.username parameter is correctly set in the Export to File for Paginated Reports action. The parameter should be set to the effective username within the token that applies the RLS rules.
If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.
Thank You.
Hello,
I do not want to set identity.username to a user in the AAD. I want to set it to a custom value that I want to use as a filter.
E.g. I have Product table with a Color column. I want to filter all products that are green in color. So, I will be setting the username to green and it should filter the result accordingly.
Thank you