Forum Discussion

Mahi_12's avatar
Mahi_12
Regular Visitor
8 years ago

Pulling VSO data to Power Bi using Odata Feed

Hi,

 

Iam trying to get the VSO data using Odata feed.A question regarding the URL:

https://office.analytics.visualstudio.com/DefaultCollection/_odata/WorkItems?$filter=(Project/ProjectName eq 'A' or Project/ProjectName eq 'B') and WorkItemType eq 'Bug' and (CreatedDate gt 2017-06-01T05:43:00Z or ResolvedDate gt 2017-06-01T05:43:00Z) 

1.How to change the Timezone to IST?

As the bug count in the report created is not matching with my VSO query.

 

Thanks.