Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Extra spaces causing duplicate line when loaded.

Dear Experts,

 

I have raw data that has extra spaces similar to this highlighted in yellow: When i load in PBI, it creates an extra line similar to to the 2nd screenshot: The file is in CSV. I initially thought removing the description collumn will solve the issue but its not. The moment i load the file will create the extra line. 

 

 

Appreciate your advise.

 

Regards,

Leo

 

 

1 Reply

  • SpartaBI's avatar
    SpartaBI
    Community Champion

    Anonymous you can PM me and we could look together in zoom if you want