Pre-filtering Power BI 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.
PREREQUISITES:
Where to find FILTERS and FILTER VALUES:
- Power BI Filters are applied to specific Fields in data Tables.
- Filter names can be found in the Fields pane that is accessible in Report Editing View
- Filter values can either be obtained from the Visualizations and Filters pane in Report Editing View or Filters pane in Report Reading View
Filters from Microsoft Power BI are passed to Metric Insights in the following format: table.column
2. Identify Filter names in Power BI
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.Channel
example in the screenshots below (View Section 1 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, go to Section 1.1).
1. Adding Microsoft Power BI Filters to Metric Insights
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 information that is going to be fetched.
To do so, click [+ Microsoft PowerBI Filter]. Next, you can choose whether you are going to define filters manually or via the existing Dimension Values.
1.1. Enter manually
-
Microsoft PowerBI Filter Name: Define the name of the filter from Microsoft Power BI
- Observe this format
table.column
- For details, refer to How to find Filter names in Microsoft Power BI?
- Observe this format
- Filter Values: Choose "Enter Manually"
- Save to proceed
- Click [+Add Value], and in the opened pop-up, type in the name of the filter value. Save your entry.
- All added values appear in the Values list
- Identify Filter names in Power BI explains where you can find Filter Values
- Save your entries
1.2. Using Dimension Values
-
Microsoft PowerBI Filter Name: Define the name of the Filter from Microsoft Power BI
- Observe this format
table.column
- For details, refer to How to find Filter names in Microsoft Power BI?
- Observe this format
- Filter Values: Choose "Map to Dimension Values"
-
Dimension: select a corresponding Dimension from the drop-down list and all its Values are going to be loaded to the Values list automatically
- This Dimension should have already been created in Metric Insights. For reference, see Basic Dimensions
- Save your entries
NOTE: Dimensions used here must have Values that exactly match the Filter Values in Microsoft 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.
2. How do I add filters to a results set from Power BI?
- Click the Pencil icon in the Filter field to open configuration settings
- When a Filter is added, you can use it for "All Values", "Only Selected Values" or ignore it
3. Deleting Filters
To delete a Filter:
- Click the Filter icon in the Report field
- Click the Trashbin icon in the respective row