Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
If I right click on a cell such as the Create Date in browser using report in Power BI Service, I use the Copy>Copy Value option.
But if I paste the value into Notepad instead of getting 06/09/2011 I get:
"Thu Jan 06 2011 00:00:00 GMT+0000 (Greenwich Mean Time)".
Please fix this bug as our users are actively using this feature and expect to get what is displayed in the cell.
I'm not 100% sure that is a bug vs design issue. The underlying data is what you are getting, not merely the format of it. One workaround is to get data via Analyze in Excel.
But if you think it is a bug, you should report in the Issues forum where MS PM's are actively engaged and will look at. They don't often participate in the user help side. Issues - Microsoft Power BI Community
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.