Data export from PowerBI to csv

[Anonymous]

Hi everyone.

I'm facing strange error during data export from PowerBI Desktop to csv.

In PowerBI table with sales values is displayed OK, with sales calues as numbers.

But while export to csv, some (not all) salesvalues are converted to date (eg. 800 in PowerBI is converted to 20-06-15).

What could be the reason?

[amitchandak]

@Anonymous , can share a sample of those lines.

can you export as excel and check if you face the same issue.

[Anonymous]

This is what I get while export to csv.

From PowerBI Dekstop I cannot export directly to Excel.

[amitchandak]

@Anonymous , Margin is coming like a text, Can you check data type and data format and correct that if needed

Check in column/measure tools

[Anonymous]

I don't think this is the reason.

I've checked data export from my PowerBI report to .csv on my colleague's computer - and it works perfectly, without any strange conversions.

So the same PowerBI table exported on two different computers returns two different files: one with correct values and one with values converted to date format.