Forum Discussion
CSV is not loading properly in Power BI, Data missing in loading process
There are 4 CSV files….when I loaded into Power BI,3 files loaded perfectly but one file loaded with some missing records. I check some blogs/forums in the Power BI community that we should go for Ex...
PhilipTreacy
Super User
Super UserHi Priti_Kaur
Do your data clean-up/transformations in Power BI.
If one of the CSV's is 'missing data' then that indicates that the data in that CSV isn't in the same format as the other 3 CSV's. Double check it to make sure.
In Power Query you can right click the query and then turn off 'Include in report refresh'.
Regards
Phil