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
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
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.
- v-saisrao-msft
Hi bhavya11,
We greatly appreciate your efforts and the update.Is the issue been resolved from your end. If you have any further concerns, please feel free to reach out to us.
If this helps then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Hope this works for you!
Thanks.
As mentioned in my previous post, there exporting paginated report with RLS using Effective Identity with custom string in username is not supported. So, I implemented a workaround by passing the required RLS parameters in the parameter-value collection in Paginated report.' I added report parameter and query parameter for each column that I use for RLS. Then I added filters on each of those columns in the DAX Query.
Thank you
Thank you.
- v-saisrao-msft
Hi bhavya11,
Thank you for sharing your findings. I appreciate the effort you put into troubleshooting and updating the community with your workaround. It's excellent to hear that you successfully implemented Row-Level Security (RLS) by passing the required RLS parameters in the parameter-value collection of the Paginated Report.
Your approach of:
- Adding report parameters and query parameters for each RLS column,
- Applying filters in the DAX query,
This insight is highly valuable for others encountering similar challenges, and your detailed explanation will certainly benefit the community.
If you find this post helpful, kindly mark it as the solution and give it a kudo. This will assist other community members in easily locating useful information.
Thank you.