Forum Discussion
Missing data in Power BI Desktop from Dataflow
Hello Anonymous
this could be due to a failed data transformation step that has been automatically added at the end of your dataflow.
Although I doubt it in your case...
Background: If you don't specify a type for your column in dataflows, then after saving and closing, 2 steps will automatically be added at the end of your query: A text transformation and a removal of error values.
This could explain the behaviour you are seeing.
Otherwise I would say it is a bug.
Hi ImkeF
I checked my flow and activated_date is formatted as a date and I don't see any additional steps, everything seems normal.
In the Dataflow, specify the text type for this column, and convert it to a date after loading in the dataset.
In general, in dataflows, it is better to store everything in a text type, and convert it after loading into a dataset. There will be fewer such bugs.
Poohkrd this trick doesn't work either
Could you find any solution for it?
