Forum Discussion
MarcUrdang
6 years agoPost Patron
dates
my date in Excel is dd/mm/yyyy PBI reads in then as mm/dd/yyy so my data only pulls through January for example. How do I get PBI to read it so that the date gets read as per Excel .. or do I...
- 6 years ago
Hi MarcUrdang ,
We can add cultures parameter for example "gsw-FR" or "ar-BH" in the end of Table.TransformColumnTypes function to meet your requirement.
Best regards,
v-lid-msft
6 years agoCommunity Support
Hi MarcUrdang ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,