Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
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