Décio on 04 Jan 2019 18:33:49
It would be a nice addition to have "identify errors" in the Transform tab.
Today there is "replace errors" in the Transform table but I can only replace if I can identify an error.
Here is the case I had today:
I used the same CSV file in two different PBI models.
One of them I did a sum of a #div/0 collumn and the other I did not.
When updating the values from the source file, PBI identified a query error in the file that had the sum of #div/0 but not in the other PBI.
Since there are more than a 1000 lines and numerous collumns that would be near impossible to find that error.