Forum Discussion
M Query filter on Value.FromText
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
