Filter and share a Power BI report
Sharing is a good way to give a few people access to your dashboards and reports. What if you want to share a filtered version of a report? Maybe you want the report to show only data for a specific city or salesperson or year. This article explains how to filter a report and share the filtered version of the report. Another way to share a filtered report is to add query parameters to the report URL. In both cases, the report is filtered when recipients first open it. They can clear the filter selections in the report.
Power BI also offers other ways to collaborate and distribute your reports. With sharing, you and your recipients need a Power BI Pro license, or the content needs to be in a Premium capacity.
Follow along with sample data
This article uses the Marketing and Sales sample template app. Want to try it?
Install the Marketing and Sales sample template app.
Select the app and select Explore app.
Select the pencil icon to open the workspace that you installed with the app.
In the workspace content list, select Reports, then select the report Sales and Marketing Sample PBIX.
Now you're ready to follow along.
Set a filter in the report
Open a report in Editing view and apply a filter.
In this example, we're filtering the YTD Category page of the Marketing and Sales sample template app to show only values where Region equals Central.
Save the report.
Share the filtered report
Clear Send email notification to recipients, so you can send a filtered link instead, select Share report with current filters and slicers, then select Share.
Select Share again.
Select the Access tab, then select Manage shared report views.
Right-click the URL you want, and select Copy link.
When you share this link, recipients will see your filtered report.
Limitations and considerations
Things to keep in mind about sharing reports:
- When you share a dataset by managing permissions, by sharing reports or dashboards, or by publishing an app, you're granting access access to the entire dataset unless row-level security (RLS) limits their access. Report authors may use capabilities that customize user experiences when viewing or interacting with reports, for example hiding columns, limiting the actions on visuals, and others. These customized user experience do not restrict what data users can access in the dataset. Use row-level security (RLS) in the dataset so that each person's credentials determine which data they can access.