Users can add custom parameters to Power BI reports in order to filter the report from Aurena Client itself.
Manage Reports page facilitates this option by making use of Query string parameter syntax for filtering, provided below are the detailed steps that a user should follow to enable filtering.
Sample Syntax : “URL&filter=Table/Field eq 'value'” For more information regarding Query String Syntax go to : Microsoft Power BI Documentation
Ex :- &filter=Store/Territory eq '{PARAM1}'
Where “PARAM1” is the value that would be passed as the parameter for the report which could be set to any value in the Report Parameters section.
Complete URL would be as below where the highlighted section shows the added filter
Note that the user has to type the exact text that was specified in the URL as the parameter name in this window as well for this to work, as in the above example in Step 2 the name which was set as Parameter name was “PARAM1” hence in Step 3 for the Parameter Name this exact text needs to be entered as shown above and then you can set any value as the parameter value.
Once this set up correctly when the user views the published report in Aurena the report will be processed with the provided filter value.