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.
Hi, this is my first post, so be patiente with me. I have excel files with columns DateOfSale and DateOfRelease. It has value stored as decimal number, formated as short date (dd/.mm/yyyy). When I use this xlsb. file as source in PowerBI, in Columns date 31/1/2011 is displayed, not 04/01/2015 as is correct (for example). Advice pls? This is fileFile
Solved! Go to Solution.
Hi Tomislav. The date format used in the Query and Data views are based on your machine's Windows locale. You can control the format that's used in the reports from the Modelling ribbon either in the Data view or Report view. There are more details here:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-data-types/
hope that helps
Will
Hi Tomislav. The date format used in the Query and Data views are based on your machine's Windows locale. You can control the format that's used in the reports from the Modelling ribbon either in the Data view or Report view. There are more details here:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-data-types/
hope that helps
Will
Covering 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.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |