cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Page level and report level filter restriction

Hello,

 

This may be because I am using the free version of Power BI, but is there a way to restrict those that I share my dashboard and report with from changing the page/report level filters? I would much rather have one large data set and be able to re-create the same report just by using page/report level filters.

 

That may seem confusing, so here is an example:

-My report is connected to an access database that contains data for 10 different teams.

-There are 10 different teams that I am creating a dashboard/report for.

-I only want the teams to be able to see their own teams data and report.

-I want to be able to create one report, and then copy and paste it into 9 other reports (one for each team) and simply just change the page level filters for each team.

 

My current understanding and concern is that someone could simply go to the page/report level filters on their report and change it to see the other teams data and report.

 

My current solution is to just create a query in Access for each team, and then create 10 reports that are connected to their respective query, but this can be very time consuming.

 

Is there a way to restrict the user that I share the report with from changing the page/report level filters on the free version or even the paid version of Power BI?

 

 

Thanks!

-Dan

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resident Rockstar
Resident Rockstar

Re: Page level and report level filter restriction

The only data security natively available in any version of Power BI is binary: access to all of a published dataset, or no access to a published dataset.

 

The only sources that support role-based security are SSAS Multidimensional and Tabular when accessed via the AS Connector or Enterprise Gateway in a live connection. Any other data source will be queried or refreshed based on stored credentials (by default those of the report publisher in most cases) and will only have the binary access/no access security described above.

 

Filters are explicitly not a security feature. Any attempt to utilize them as such is misinformed and ill-advised.

View solution in original post

1 REPLY 1
Highlighted
Resident Rockstar
Resident Rockstar

Re: Page level and report level filter restriction

The only data security natively available in any version of Power BI is binary: access to all of a published dataset, or no access to a published dataset.

 

The only sources that support role-based security are SSAS Multidimensional and Tabular when accessed via the AS Connector or Enterprise Gateway in a live connection. Any other data source will be queried or refreshed based on stored credentials (by default those of the report publisher in most cases) and will only have the binary access/no access security described above.

 

Filters are explicitly not a security feature. Any attempt to utilize them as such is misinformed and ill-advised.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors