Forum Discussion
Time Exporting with Date
- 2 years ago
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
Thanks your solution Kishore_KVN
Hi, MStark
Pls is your current problem solved?
After my testing, if you click on the 3 dots in the upper right corner of the visual and select export data, there will indeed be a date prefix, as shown in the image below:
If you want to keep the format of the time, you can right-click in the table view and select the copy table function:
Go to Excel and paste it:
If your columns are not in the same table, you can create a calculated table, use the Summarize function or Addcolumn function to summarize the columns to be copied in a table, and then use the copy table function.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- MStark2 years agoHelper III
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