Forum Discussion
Solved
Time Exporting with Date
Why is my column from Power BI exporting to excel as text YY-MM-DD HH-MM-SS? The column is formatted as Time in Power BI and is showing correctly in the visual. Its just when I export is showing in t...
Thanks Anonymous
I found that if you export from Power BI online it exports correctly. This is only an issue when using BI Desktop. For now, I will continue using the online version so it exports correctly
Hello MStark ,
As there is only time in that column it will add a generic date as prefix to make it as required, combine both date and time columns in Power BI then export it into excel which will give proper format.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!