Forum Discussion
Power BI Paginated reports prefiltered data (run from Dynamics 365)
Hi,
We've got SSRS reports and want to convert them into Power BI paginated reports.
1) SSRS report uses FiteredView (filteredaccount), Power BI paginated report has account table only, in this case how the secuty roles will work?
2) We want to run the paginated report from Dynamics 365 with a prefiltered data, is it possible? Can we use CRMAF_ prefilter sale as with SSRS reports?
Thanks
1 Reply
bradsyMicrosoft Employee
Parameters should work as normal, but sound like your want row level security. This article might help? https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-rls
Or if you create a Power BI Dataset and use that as the datasource, then data is filtered at that level. https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls