Forum Discussion
Helper ICouldn't load the data for this visual: Expected equal values
Never seen this error before and couldn't find anything on Google.
I am creating a table visual to track the route between two tables and the relationships between them. My goal is to see if an ID is missing between these tables. Why? Because I have a row where the Job Name populates, but the Count of Job Name is blank. I've previously found that this error indicates a missing ID in the path between tables. Here it is below:
This starts with the "Job" table, flows through two other tables, then arrives at the "Time Entry" table. I included a column from Job, the id for the job table, the id's for every linking relationship between the Job and Time Entry tables, and the id and a column from Time Entry. It looks a little like this:
| Job Name (from Job) | Job id | Job Phase id (matches Job id) | Job Phase id (matches Team Assignment id) | Team Assignment id (matches Job Phase id) | Team Assignment id (mathces Time Entry id) | Time Entry id | Column from Time Entry | Count of Job Name (from Job) |
This is the table that gets the error. HOWEVER, if I move Job Name to the end of the table, everything displays. I was investigating this idea because the data was off, so an error message makes sense. What doesn't make sense is why the location of this field matters.
What could this error indicate based on the behavior of the table? My best guess is that it breaks because Job Name has a value and Count of Job Name does not. I was expecting equal values, as they are the same field, so maybe that is why it breaks.
1 Reply
- lbendlin
Super User
That's a good one indeed. As you probably know Power BI always aggregates, unless you tell it explicitly not to. In a table visual that happens as well, but the order of the columns should not make a difference on the outcome of the aggregation.
Since you show multiple rows with the same text you must have disabled aggregation manually, or have included a unique value column.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
