Filtering Power BI Embedded Reports with URL parameters
Testify offers the option to include reports powered by Power BI that are directly embedded into the Testify app for insights about the usage of Testify.
Sometimes it might be desired to link from other systems to certain reports and filter for certain values to show a specific view on the data. For example you might want to link to data about a specific test object, managed in your ERP system. Using URL parameters you can link to a certain report in Testify and filter the report to only display data about that specific test object. In fact you can use the URL parameter to filter on any data that the report offers as a filter on its right-hand side:
Filtering a report can be done by using the standard Power BI URL filter parameter described in this documentation by Microsoft: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
Whenever you link to a report in testify and specify the filter parameter in that URL, testify passes it’s value as-is right down to the report itself where it will be interpreted by Power BI.
A simple example of a filter is to filter for one value using the eq filter, but of course you can use any filter as described in the documentation by Microsoft. The syntax for that filter is filter=Table/Field eq 'value'. This means that you will set a filter for a field within a table. That field needs to have the value of 'value'.
To find out the specific table and field names for your use-case, send a request to support@testify.io
In the following example we set a filter for the test object by specifying the filter URL parameter as filter=ChecklistAnalysis/TestObjectTitle eq 'Standort 1'. Of course you additionally have to make sure, that the URL is properly URL-encoded and you need to handle special characters in the table and field names as described in the Microsoft documentation. The URL parameter for this example would look like this: filter=ChecklistAnalysis/TestObjectTitle%20eq%20%27Standort%201%27
