Power BI - Data refresh doesn't work for CSV File

Question

I am currently loading a local CSV file. If I add a column/row in the file, I want to refresh the data in my power bi. If I press refresh in the Query Editor, nothing happens. Do you have any ideas on why that isn't working?

EDIT

It works perfectly for MS Excel but doesn't work for CSV. Why? 

Answer 1

Open the advanced editor, then you will find the original number of columns that are defined. Delete that number so that it will work.

Want to learn more about Power BI, Come & join Power BI tutorial. Also, enroll in Power BI course online to become proficient in this BI tool.