Forum Discussion

sathishkumark24's avatar
sathishkumark24
New Member
2 years ago
Solved

Export the Data from Power BI without Timestamp

Hi ,

 

Trying to extract the table data from Power BI to excel but in the date columns it is reflecting with Timestamp. I need only date range and timestamp sholud be removed while exporting the data to excel. I changed the date format in Table View to Data Type (Date) and format as Short date also in transform data changed to data type to Date. But still while exporting the data its coming up with Date with timestamp. Is there any solution for this resolve plz. It will be helpful for me.

 

Thanks

Need Help

2 Replies

  • anmolmalviya05's avatar
    anmolmalviya05
    Super User
    2 years ago

    Hi sathishkumark24 , Hope you are doing good!
    Make sure you change the datatype in Power Query editor.
    I tried this and it's working fine.
    If you still face the issue then please share a demo pbix file for better understanding.

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, sathishkumark24 

    Based on your information, I create a new sample table:

     

    Then create a calculate column and try the following dax:

    DateOnly = FORMAT('Table'[Original DateTime], "yyyy-mm-dd")

     

    Create a table visual and put DateOnly field in it, export data:

    Open this file in Excel:

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.