One of the helpful options of PowerBI Stories is the power to set report-level filters in order that the knowledge displayed inside it may be related to the patron.
What are Filters in Energy BI?
Filters in Energy BI distill and kind knowledge and data primarily based on a particular standards. That’s, you may choose explicit fields or values inside fields and think about solely the knowledge associated to that. As an example, in case you have a dataset associated to gross sales of a retailer, you should use Filters to view a report having solely the info for the chosen features.
For instance, if you happen to solely wish to see the gross sales data within the Charlotte space within the yr 2019, all you need to do is to place the filtering criterion as 2019 and Charlotte of their respective fields. The report of gross sales will instantly make modifications accordingly and solely present the graphs and visuals particular to gross sales statistics in Charlotte and within the yr 2019.
How Does PBRS Help Report-Degree Energy BI Filters?
PBRS has all the time supported passing report-level Filters to Energy BI experiences in order that when the report is routinely generated, it’s delivered with simply the correct data. In reality, PBRS customers love utilizing Information-Pushed subscription schedules to run a number of cases of Energy BI experiences, with filters configured by way of the data-driver after which delivered to knowledge pushed recipients, the ensuing exported output file containing solely the knowledge related to the recipient.
One problem that has all the time plagued the extra superior consumer, nevertheless, is when a Energy BI report comprises greater than a few filters to configure. Because the variety of report filters will increase, the method of organising the PBRS schedule shortly turns into tedious and susceptible to errors.
let basicCustomerFilter = …..;
let advancedRegionFilter = ……;
let employeesFilter = …..;
return [basicCompanyFilter, advancedRegionFilter, employeesFilter]
With a view to streamline the creation of the filter perform for PBRS data-driven schedules, it is suggested to construct a SQL perform or Saved Process that accepts a key identifier and returns the complete perform. That is so that each one the logic will be modified in a single place and doesn’t must be created in an inline SQL question.
SELECT dbo.Custumer.CustomerId, dbo.Buyer.EmailAddress, dbo.GetPowerBiFilterFunction(Buyer.CustomerId) AS PowerBiFilter FROM dbo.Buyer
Tell us in case you have any questions or ideas about this characteristic.