Forum Discussion
Date issues with Sharepoint file sources
The March update (2.56.5023.861 64-bit) got installed this morning. Unfortunately, it's broken the ability for the Power BI Desktop Query to understand dates from a sharepoint folder source. This f...
Buzz123,
Deinstalling the Power BI Desktop, and then installing the older version will work... at least with me. Luckily I'm keeping the versions I'm installing in my DSL (Definitive Software Library).
= SharePoint.Files("https://my.sharepoint.com/sites/sitename/", [ApiVersion = 15])
change APIVersion in the source line from 15 to 14.
= SharePoint.Files("https://my.sharepoint.com/sites/sitename/", [ApiVersion = 14])
the ApiVersion 14 works with dates other than US
:smileyvery-happy: It worked! (changing the API version from 15 to 14). Thank You ozhug !
thank you, it works fine for me !!!
