multi-entity filters error

[ysapiyev]

Hi everyone,

I have a report in Power BI desktop with live connection to multidimensional SSAS cube. When I try to set interaction between visuals, which has two categories, I get error :

The expression in property 'Value' on Calculation 'H0' contains an error: 'The query contains multi-entity filters which are not supported with the current model.'.

How it can be solved?

Regards,

Yerkhan

[ysapiyev · Accepted solution]

To avoid this error, I used item name as grouping, and group by date. Works fine.

Regards,

Yerkhan

[tomhafner]

Is there still no solution for that? Have SQL 2017 14.0.223.1 (CU8) u. PowerBI 2.59 (June 2018) in use.

Since the error is already known for a year (SQL2017 RC2) I would expect a solution already!

How do you explain to your customers that after the update to 2017, reports will not work anymore and he'll have to rebuild them somehow just because Microsoft. The customers who use PowerBI are very well paying enterprise customers - which one do you really want to annoy?

[Anonymous]

@ysapiyev,

What version of SSAS do you connect to? What version of Power BI Desktop do you use?

Please check if you get similar scenario as described in the following similar thread.

https://community.powerbi.com/t5/Issues/Support-multi-entity-filters-on-Multidimensional-models-for-...

Regards,
Lydia

[ysapiyev]

@Anonymous,

I use March version of Power BI, SQL Server 2017 and SSAS version 14.0.

I checked this url, I have similar issue, but I didn't see solution in that topic.

Regards,

Yerkhan

[Anonymous]

@ysapiyev,

Please check  v-haibl-msft's last reply in that similar thread.

Regards,
Lydia

[ysapiyev]

@Anonymous,

Could you post link to this message? I looked at profile and couldn't find post.

Regards,

Yerkhan

[Anonymous]

@ysapiyev,



Regards,
Lydia

[ysapiyev]

@Anonymous,

Thanks. I'm using latest SSAS, and in this version, there is multi entity filtering error. So, issue will be resolved in SSAS 2018? Issue was stated in 2017 and there is no solution yet, as fas as I understood.

Regards,

Yerkhan

[Anonymous]

@ysapiyev,

There is no timeline for this issue, please vote the multi entity filtering against older models idea in ideas.powerbi.com.

Regards,
Lydia