Bug: Matrix "Expand all down one level in a hierarchy" button

[Anonymous]

Hi Power BI,

The matrix worked fine with the "Expand all down one level in a hierarchy" button when it was newly setup. When there is changes in the SQL code, the "Expand all down one level in a hierarchy" no longer working OK and error message popped-up such as follows:

Couldn't load the data for this visual
Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them. The exception was raised by the IDbCommand interface.

It is very frustrated to keep reworking on the matrix visual as new.

[v-qiuyu-msft]

Hi @Anonymous,

Would you please share more information about "When there is changes in the SQL code, the "Expand all down one level in a hierarchy" no longer working"? Please share detail steps for us to reproduce the issue. 

From your description, it seems you are connecting to SQL database. Is it Import mode or DirectQuery mode? 

The latest desktop version is 2.59.5135.781, which Power BI desktop version do you run? 

Best Regards,
Qiuyun Yu

[Anonymous]

Hi @v-qiuyu-msft,

Yeah, using Direct Query mode.

I am using June version 2.59.5135.421.

In brief, my report is built using Matrix visuals, when I expand from Region to Zone, it is working fine. When expanded further to Branches, the attached error message will display. 

May be there is limitations in the Matrix visuals such as only allowing a certain number of filters to be setup, etc.

Anyway, we have fixed the issue in the SSIS coding and SQL server. 

Thank you.

Regards,

Rudy