Forum Discussion
Problems with clusters in the Power BI app
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!
2 Replies
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
-
suggest making sure to create and use your own date table?
Here are more details: Auto date/time in Power BI Desktop - Power BI | Microsoft Docs
If I have misunderstood your meaning, please provide more details.
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.
-
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.
