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:
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.