Forum Discussion
SharePoint date differs from Power BI date
This seems to work fine! not too difficult but requires work on each date column.
These solutions work only if you are not republishing back to a server/
For me, ive tried all of the above, it works for a little while then the server weirdly reverts back to the date -1.
The only solution ive now gone with is reverting back to api 14. Im hoping it works as ive reepublished to the server. So far so good.
Changing the API version from 15 to 14 worked for me. Deleted all steps except source after changing and redid what I had done.
Question is, what ramifications does changing the api version have?
Has anyone confirmed their locale is set correctly in Sharepoint for the entire site?
And also in Power BI Service? (NOT power BI Desktop)
https://docs.microsoft.com/en-us/power-bi/supported-languages-countries-regions
