Forum Discussion
Mahi_12
8 years agoRegular Visitor
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.
2 Replies
- v-chuncz-msftCommunity Support
You may refer to the expression in link below.
http://community.powerbi.com/t5/Desktop/Dashboard-date-not-reverting-from-IST-to-PST/m-p/341337
- Mahi_12Regular Visitor
Thank you.
In the above link we are creating a measure but i need to change the timezone in the Odata Query so that it gets coverted from PST to IST