Forum Discussion

pkumarsharma's avatar
pkumarsharma
Regular Visitor
3 years ago
Solved

Sharepoint API 14 or API 15

Hi   I have a date issue while bringing in my sharepoint list to power bi. This is easily resolved if i use Sharepoint API versin 14   Is there any issue if i use Sharepoing API 14 or there will ...
Need Help
  • KNP's avatar
    KNP
    3 years ago

    Welcome to the wonderful and annoying world of dealing with timezones in Power BI.

    If 14 returns what you want, I would use that. 

     

pkumarsharma's avatar
pkumarsharma
Regular Visitor
3 years ago

My Sharepoint site settings are

 

My Windows language settings 

 

My Power Bi Settings

 

 

I have made sure that everywhere i am using australia, But still when I import the data with API version 15, The dates are reduced by 11 hours and present a prior day.

KNP's avatar
KNP
Super User
3 years ago

Welcome to the wonderful and annoying world of dealing with timezones in Power BI.

If 14 returns what you want, I would use that. 

 

  • afiqhaziq's avatar
    afiqhaziq
    Frequent Visitor
    2 years ago

    Im using API =14 for 6 months and worked great until recently all my connection become error as below

     

    Been tring to solve this for days, but nothing works. Of course using API =15 works but then Ih= hav to repeat the steps of transforming the data gain