How can we improve Power BI?

Add support for parameters to Power BI aggregations

Currently, if you'd like to filter a table using a what-if parameter or a disconnected parameter table, this is not supported in Power BI aggregations. This is true even if the parameter table is stored in stored in dual mode, similar to the dimension tables.

Instead, if you try to filter by a parameter, the query will revert to DirectQuery mode and not hit the aggregation tables. See this blog post for more detail.
https://www.sqlgene.com/2019/03/31/parameters-not-yet-supported-in-power-bi-aggregations/

My understanding is this is currently by design because the parameter value is neither pre-aggregated nor has any mapping.

7 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Eugene Meidinger shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.