Invalid MDX command with UNSUPPORTED:>50 CHARACTERSTICS

[Anonymous]

Hi All,

I am getting the error-"Invalid MDX command with UNSUPPORTED:>50 CHARACTERISTICS" when I am connecting Power BI Desktop to BEX query and adding more than 50 objects. In my report, I have been asked to show 

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

This is a Shortcoming of SAP BW product.

When adding more than 50 free characteristics in the query definition, as the query is executed the following message shows up :

Maximum number (50) of drilldown n characteristics is exceeded

The diagnosis of the message shows the following :

The maximum number of drilldown characteristics is restricted to a value of 50

Procedure :

Reduce the number of drilldown characteristics by filtering to characteristics, or pulling characteristics back into the free characteristics.

refer:

https://userapps.support.sap.com/sap/support/knowledge/en/2630982 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Anonymous]

I tried it but it didnt work, Power BI treat free characteristics as a separate dimension

[Syndicate_Admin]

@Syndicate_Admin , check if these can help

https://answers.sap.com/questions/12852732/bo-42-invalid-mdx-command-with-unsupported50-chara.html

https://answers.sap.com/questions/11375707/mdx-error-reason-invalid-mdx-command-with-unsuppor.html