Data is partially loaded in the Power BI while the csv is full

[aliebadi]

Hi,

I have a dataset in csv format that I import into Power BI. It consists of 58 columns and 5251 rows. Everything is impored correctly except 5 specific rows that I'm trying to understand why is it happening and how can I fix it.

As you can see in the screenshot, all of the columns after agent_name are empty in Power BI only for these 5 rows while in the csv file I have no balnk and empty rows. It only happens for those rows and certain columns and the first 20 show fine. Could you please help understand? Thanks.

[Kishore_KVN]

Hello @aliebadi ,

Can you please check if there are any cells merged for the agent column in the CSV file. If yes please unmerge them and clean it in base file itself then it will reflect properly in Power BI.

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[aliebadi]

Thank you for your reply. I don't merge anything in csv. It's just a simple flat csv file. Or maybe could you help me find out please?