Missing data in Power BI Desktop from Dataflow

[Anonymous]

Hello there!

I have a dataflow connected to the database and everything is fine, here is example of one row. 

When I download data from DF to Power BI Desktop there is an issue that I have missing random data in activated_date (as you can see there is a date 2/9/2023 in DF), but it's missing in PBD, I don't know why, but this only occurs only on some part of rows, not all.

Here is PQ view, everything looks normal excepts this activated_date, I tried to refresh all sources and still nothing. Is this a bug?

[ImkeF]

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.

[Anonymous]

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.

[Poohkrd]

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.

[Anonymous]

@Poohkrd this trick doesn't work either

[Anonymous]

Could you find any solution for it?