cancel
Showing results for 
Search instead for 
Did you mean: 

SharePoint folder - Regional settings not applied

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 

Status: New
Comments
v-qiuyu-msft
Community Support

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