Параметры на уровне Power Query

In this feature overview video series, we highlight new capabilities included in the latest update to #Microsoft Power BI.

Prior to dynamic query parameters, the only way to set parameter values was through Power BI Desktop. This new feature allows parameters to be updated dynamically based on filter or slicer selections made by report viewers in reading view. This feature will be supported only for those DirectQuery sources that use the M Engine and will allow the setting of parameters that are an exact value or a set of values within a slicer or filter card.

This feature can also be useful for query performance optimizations. By binding columns to query parameters, model authors have additional control over how filter selections get incorporated into DirectQuery source queries. If the model authors understand the intended semantics of their filters, then they often know how to write efficient queries against their data source; therefore, they can ensure filter selections get incorporated into source queries…