Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data export from PowerBI to csv

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?

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , can share a sample of those lines.

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      This is what I get while export to csv.

      From PowerBI Dekstop I cannot export directly to Excel.

      • amitchandak's avatar
        amitchandak
        Super User
        6 years ago

        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