cancel
Showing results for 
Search instead for 
Did you mean: 
0

New Field Parameters incompatible with Analyze in Excel

I connected my power bi desktop model (that uses the new field parameters) with the Analyze in Excel External tools.

As far As I added only dimentions, it worked. Bud mixed with an eplicit measure I had this error:

RenatoLira_0-1652734095356.png

The error translates something like:

The column [Parameter] is part of a composite key, byt not all columns of the compostite key were included at the expression.

 

What I could deduce is that the application at PBI Desktop is at the construction of the DAX Query itself.

Somewhat, creating MDX queries through Excel something got missing.

Can you confirm that I cannot use this feature with Analyze in Excel?

Status: Delivered

Hi @RenatoLira ,

 

The error occurs because, as it says, [Parameter] is part of a compound key and you need to filter on all columns of the compound key.

 

In our investigation, we found a similar thread that explains why this error occurs in Power BI,

you can refer to:DAX Dimension Composite Key Syntax Question 

 


Best Regards,
Community Support Team _ Caitlyn

Comments
v-caitlyn-mstf
Community Support
Status changed to: Delivered

Hi @RenatoLira ,

 

The error occurs because, as it says, [Parameter] is part of a compound key and you need to filter on all columns of the compound key.

 

In our investigation, we found a similar thread that explains why this error occurs in Power BI,

you can refer to:DAX Dimension Composite Key Syntax Question 

 


Best Regards,
Community Support Team _ Caitlyn