Forum Discussion
Missing data in columns when load from Dataflow
I have a Dataflow with all the data, refreshed every midnight.
However, when importing it to PBI Desktop from the Dataflow, there are missing values in some columns. The missed data are on the date before the latest refreshed date.
Example: refreshed date is midnight 2022-10-28.
Data in Dataflow:
| Date | Column B | Column C |
| 2022-10-27 | b1 | c1 |
| 2022-10-26 | b2 | c2 |
| 2022-10-25 | b3 | c3 |
| 2022-10-24 | b4 | c4 |
But when getting it for PowerBI Desktop:
| Date | Column B | Column C |
| 2022-10-27 | null | null |
| 2022-10-26 | b2 | c2 |
| 2022-10-25 | b3 | c3 |
| 2022-10-24 | b4 | c4 |
Any ideas anyone?
2 Replies
tamnm1601 , That is strange, Please refresh the data in the report again and try .
Also how you have checked data flow data?
I've refreshed it many times. Also re-created the table in Desktop and the connection.
I'm the admin of the Dataflow. So to check it, I just go to Edit Table and see the whole thing. No error alerts been thrown from neither Dataflow nor the columns in Desktop.
I also see some folks in the community coped with the similar situation as mine but in vain of solution.
