Pre-filtering Power BI Cloud Data for External Reports
Before collecting data from Microsoft Power BI objects, you can pre-filter it. This allows you to focus on the exact information that is required for analysis and exclude the data that is irrelevant for you and your research.
How to Find Filter Names in Microsoft Power BI?
Where to find FILTERS and FILTER VALUES:
Filters from Microsoft Power BI are passed to Metric Insights in the following format:
2. Identify Filter names in Power BI
[6.2.4] Slicers are now supported as a Filter Type for Microsoft Power BI Cloud External Reports.
When in Report Edit mode:
- In the Fields pane, you will see table and column names
- Join the table and column name with a period, like
table.column(no space between the names)
- This is the Filter name to use when building External Reports in Metric Insights
- See the
Daily Sales 2016.сhannelexample in the screenshots below (See the Configure Filter section of this article)
- Filter values are displayed in the Visualizations and Filters pane. You can use these Filter values when adding them manually to External Reports (For more information, see Enter Filter Values Manually)
How to Add Microsoft Power BI Filters to Metric Insights External Report?
When creating an External Report fetched from Microsoft Power BI, after you define the Report that should serve as a Data Source, you may pre-filter the information that is going to be fetched.
1. Add a New Filter
Access the Configuration tab of your External Report
- [Manage Filters]
- [+ Filter]
2. Configure Filter
Microsoft Power BI Cloud Filter Name: define the name of the Filter from Microsoft Power BI
- Use this format:
- For details, refer to How to find Filter names in Microsoft Power BI?
- Use this format:
- Display Name: specify a name for the Filter value which will be displayed in the External Report Viewer
- Select the Filter Type:
- Regular: represents a regular Power BI Filter
- Slicer: is a more user-friendly Filter type which serves for displaying Power BI Slicers in External Report
- Select whether the Filter is a "Single Value" or "Multi-Value"
Both Regular Filters and Slicers are configured in the same way. Proceed to the next step to provide values for the chosen Filter Type.
3. Provide Filter Values
Note: The Values provided in an External Report Filter must exactly match the Filter Values in Power BI (if the values do not match, the Filter will not work).
- Identify Filter names in Power BI explains where you can find Filter Values
- Filter Values: "Map to Dimension Values"
- Sort: select the sorting order for the Filter Values
Dimension: select a corresponding Dimension from the drop-down list. All its Values are loaded to the Values list automatically
- This Dimension should have already been created in Metric Insights. For reference, see Basic Dimensions
4. Set Defaults for your Filters
Configuring defaults allows content builders or administrators to define Filter defaults for users viewing the External Report. Defaults may be set the same for everyone, or applied based on a User Map. Consequently, any number of Users will have the correct Filter Values when they open their External Report.
4.1. Set Defaults Same for Everyone
- Select "Same for everyone"
- Click on the pencil icon to edit the Filter
- If your Filter is multi-value, you can select "Pass All Values"
- Select a default value for a single value Filter, and one or more values for a multi-value Filter
4.2. Set Defaults Using User Map
Setting the Defaults via a User Map does not restrict Users from viewing non-default values. It simply sets the Values displayed upon initial viewing. If a User is not in the User Map, the system will initially display the View with no default values.
- Select "Apply based on User Map"
- Choose a User Map
- Match the BI tool Filter to a User Map Column
- Optionally, continue adding filters by clicking [+Add Mapping]. It is not required to set User Map columns for all defined filters
- Click [View], the entered data is saved automatically