The latest update of Power BI (2.70.5494.562 64-bit (June 2019)) has a crucial bug which I hope Microsoft fixes as soon as possible.
If you go to Edit Queries and have a column which has a null value. If you transform that column such as upper case the values in that column, trim that column, etc. and then after those applied steps, if you try to filter the null value out, it will NOT filter the null out.
It seems Power BI is applying those transformations to a null value (such as trying to capitalise a null value) and that step changes the null value. When you try to filter after the transformations, Power BI doesn't recognize that it's a null value anymore since it's been tranformed, and it refuses to filter it out.
I've been able to re-create this issue with a colleague as well. Here is a screenshot.
-
v-xiaoyan-msft
on:
Report jumps between two profile logins.
- iannedrs on: Error: There is an error in XML document (1, 1).
-
v-xiaoyan-msft
on:
Cannot share PowerBi reorts and dashboards to my o...
-
rayishome
on:
Get External Data: Power BI semantic models throws...
-
v-yetao1-msft
on:
Power BI Desktop April 2024 : Sort by issue. False...
-
v-yetao1-msft
on:
Power BI Service - NetworkConnectionIssue when sav...
-
v-yetao1-msft
on:
Power BI semantic model account sign in for every ...
-
Idrissshatila
on:
Timeline slicer is showing 30 & 31 March under 30 ...
-
v-yetao1-msft
on:
Publish to web url not working
- gfbentes55_sema on: PROBLEM WHEN USE JSON FROM WEB WITH LATITUDE AND L...