Problems with clusters in the Power BI app

tugusheva · ‎06-20-2022

Hello everyone I really need help. In the report, I made automatic clustering using Microsoft tools. Everything works well. After the report has been uploaded and updated in the Power BI app, the cluster-related visualizations are not displayed. The error itself: The query referenced column 'Cost prices'[account_name (clusters) 4] which depends on another column, relationship or measure that is not in a valid state. Additional information: ''
I will be grateful for your help!

v-rongtiep-msft · ‎06-30-2022

Hi @tugusheva ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-rongtiep-msft · ‎06-22-2022

Hi @tugusheva ,

Can you open the report on the Service successfully? How about the Desktop? Please try to download the pbix file and open on the desktop. What is your Service version? Could you please check the column 'Cost prices'[account_name (clusters) 4] . If it is based on a measure or another column, and whether the column works?

If you have used int values on imported files those “variables” on the desktop? The web system don’t understand as int, and the problem come when you use related() and calculation.

I have also found a similar post, please refer to it to see if it helps you.

The query referenced column 'LocalDateTable_8cb1e7c9-3581-4243-aa6e-31336bfdba9f'[Year] which depend