Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
MilaP
New Member

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 1
bradsy
Microsoft Employee
Microsoft 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 

Helpful resources

Announcements