Forum Discussion

Bhanu_chPBI's avatar
Bhanu_chPBI
Helper I
4 years ago

exporting data into excel showing some date column format issue

Im facing some issue when i export data into excel from service some of the date column in the report showing text format instead of date format

Need Help

1 Reply

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    4 years ago

    Hi Bhanu_chPBI ,

     

    I’ve tested at my side, but I can’t repro it. If you still have problem on it, could you please provide the following info to make it more clear? Thanks in advance!

    May I know what’s the date type you set for the date column in Power BI Desktop? Is this column coming from the data source itself or any calculation? Did you do any format for this column? What’s the version of your Power BI service? You could check it by Help&Support>About Power BI>Version.

    How you export the data? Did you export with current layout? Summarized data or Underlying data?

     

    Best Regards,

    Community Support Team _ Caiyun

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!