Forum Discussion
M Query filter on Value.FromText
Not sure what the error is exactly. I insert the line to filter, Close and Apply, then this:
Try to view the error, but there doesn't seem to be any info:
I backtrack through the query steps of the error table to where there is data, and supposed errors, but the columns all appear clean to me. I've seen errors in other queries/projects with the little orange Error word.
Strangely, I can just close the error popup and the accounts seem to be filtered, but then my measures and visuals break.
The measure that supposedly has the error does use Account Number, but not in the SUM portion. Very strange stuff....
This phenomenon - errors with an empty error list - typically indicates that you have values in your table that conflict with the column type (e.g. numbers in a text column). Power Query doesn't regard this as errors (that's why the list is empty), but errors are reported when loading the data.
Otherwise it is strange that you get the error with filtered data and not with the complete set.
Maybe you can try and remove the filter to double check if the error is gone?
It can be a coincidence that your data was updated while you adjusted the query, and the error was not due to applying the filter, but to updated data.
That will be all from me today.
Removing the filter does "fix" the error.
The data on the source system has not changed.
It looks like the issue is in your measures; DAX is not really my area of knowledge.
Perhaps you have some incomplete releationships after filtering (1:m becomes 1:0/m or 0/1:m).
Working off your idea I recreated the pbix with just the one query/table and no calculated measures or columns.
I then try to apply my filter and get the error still.
Interestingly, I noticed the columns that are detected as aggregate lose their aggregation with the error applied.
Hi Aron_Moore,
It seems to be that the issue is related to the measures. Could you share a sample pbix file(with just some dummy data) which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:
Regards
