Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date format is different when exported data to CSV

Hi all,   In Power BI desktop I have made a table visual with some fields added to it. Some of those fields are date fields, which are also date fields as data type. I use the format short date, fo...
Need Help
  • PVO3's avatar
    PVO3
    4 years ago

    Sorry I misread your question.

    As far as I'm aware you don't have this mucht control over CSV exports. But I'm wondering why you would exports to CSV. This is the normal behaviour for Power BI desktop but has a lot of limitations.

     

    If you export from Power BI service you can export to xlsx with less limitations and you are able to achieve to export in dd-mm-yyyy.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

In Power BI I have set the data type to date, then the date format to short date. Do I also need to adjust that in Power Query?

  • PVO3's avatar
    PVO3
    Icon for Impactful Individual rankImpactful Individual
    4 years ago

    Sorry I misread your question.

    As far as I'm aware you don't have this mucht control over CSV exports. But I'm wondering why you would exports to CSV. This is the normal behaviour for Power BI desktop but has a lot of limitations.

     

    If you export from Power BI service you can export to xlsx with less limitations and you are able to achieve to export in dd-mm-yyyy.