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.
I receive a spread sheet each month from 3 different world areas. I store these in a Sharepoint folder and then combne them in PowerBi so that i end up with one global repprt. The spreadsheets contain raw data and are not manipulated in any way. The report I get from the US has a Date/Time field. When i open it in PowerBi it sees it as text in the format MM/DD/YYYY HH:MM. When i convert that field to Date / Time it gives me an error for any field where DD is bigger than 12. It's obviously not realising teh date is in US format. Any suggestions?
Solved! Go to Solution.
When I had that error it was because there were some dates in US date format (mm/dd/yyyy) and some in the normal format (dd/mm/yyyy). So I would suggest double checking the raw data and making sure that it is all consistent.
After that, maybe check your system settings under File > Options > Regional Settings (there's two of them one under Global and another under Current File).
When I had that error it was because there were some dates in US date format (mm/dd/yyyy) and some in the normal format (dd/mm/yyyy). So I would suggest double checking the raw data and making sure that it is all consistent.
After that, maybe check your system settings under File > Options > Regional Settings (there's two of them one under Global and another under Current File).
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |