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 ,
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,