Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Missing data in Power BI Desktop from Dataflow

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?

Need Help

5 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        Poohkrd
        Advocate I
        3 years ago

        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.