CODEWITHSUNDEEP
csvpowerbidax
Mongos
Mongos

Reputation: 91

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

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 why that isn't working?

EDIT

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

Upvotes: 3

Views: 2208

Answers (2)

mafioso
mafioso

Reputation: 1632

When you open the advanced editor, you will see that the original number of columns is defined. Delete that number and it should work!

Upvotes: 2

mafioso
mafioso

Reputation: 1632

Try Options -> Data Load -> Clear Cache and afterwards refresh.

Upvotes: 0

Related Questions