SharePoint folder - Regional settings not applied

[ScottyDogg]

I have recently setup a new query from Get Data to a SharePoint folder.

This is working fine other than the Date attributes having Errors. I have my Region Settings correctly set as English (United Kingdom). If I switch the settings to English (United States) then the Date columns populate correctly. However, understandably this causes issues for all my other queries.

As such, it looks like the SharePoint folder connector is not applying/using the Regional Settings and needs a tweak!

Thanks

Scott 

[v-qiuyu-msft]

Hi @ScottyDogg, 

It looks like the Power BI desktop regional setting is US, right? 

What's the SharePoint site regional setting? 

Would you please share the date values both in SharePoint and Power BI desktop? 

Best Regards,
Qiuyun Yu