Power BI Desktop adds column to csv files upon refresh

[Anonymous]

Hi

I have a situation where Power BI Desktop adds an extra column upon refreshing the data. The scheduled refresh itself works great.

I have some R script in each file that looks like this:

write.csv(dataset, file="S:\[filename].csv")

When I edit the query it only shows "Name" and "Value" fields. The original csv file has 10+ columns.

When the refresh occurs I notice that an additional field is added to the beginning of my csv file. It seems to mock a row count.

For now I have to delete the files prior to doing a refresh, otherwise it will keep adding extra columns.

Has anyone else experienced this?

[ImkeF · Accepted solution]

Your R-script causes that. Add and additional argument: row.names=FALSE to avoid it.

See here for example about further details: http://rprogramming.net/write-csv-in-r/

[tarunsingla]

If the column names you need are fixed, then in the query editor, select all the columns you need and remove other columns. That way, any new unwanted additional columns (in subsequent refreshes) are automatically removed.

Regards,

Tarun

[ImkeF · Accepted solution]

Your R-script causes that. Add and additional argument: row.names=FALSE to avoid it.

See here for example about further details: http://rprogramming.net/write-csv-in-r/

[Anonymous · Accepted solution]

Thank so much. I have searched for weeks looking for the answer on the web. I couldn't figure out why it was doing that. Cudos!