Power BI paginated Report, Effective Identity, FolderPermissionsNotFound

Hi sgol ,

It's important to ensure that the service account used for exporting the report via Power Automate has the necessary permissions not just at the workspace level but also for accessing the underlying data, especially considering RLS is in play. The error FolderPermissionsNotFound you're encountering, , suggests there might be an issue with accessing the required resources or folders, possibly due to permission settings.

You can follow this step:

1. Double-check that the service account has not only admin permissions on both workspaces but also the necessary dataset permissions. This includes ensuring that is recognized within the RLS settings of the dataset.
2. Ensure that the effective identity being passed for is correctly configured to access the dataset with RLS. The effective identity should match the user's credentials within the app or service

Below is the link will help you:

Embed a report on an on-premises SQL Server Analysis Services (SSAS) - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.