Forum Discussion
Solved
Leading zeros getting lost in dataflow
I am developing a Power BI Desktop report connected to a dataflow via DirectQuery. One of my dimension tables has a column (Item) with the following values (greatly reduced for demonstration purposes...
Somewhere these values are being changed to numbers and the leading zeros are dropping. They must be forced to be strings in the dataflow itself. If you let it detect the datatype when storing, it will use a numerical type.
Somewhere these values are being changed to numbers and the leading zeros are dropping. They must be forced to be strings in the dataflow itself. If you let it detect the datatype when storing, it will use a numerical type.
Thanks for the answer. I understand that, but besides defining the data type as text in the dataflow (which I already did) what other steps are possible?