Pulling VSO data to Power Bi using Odata Feed

[Mahi_12]

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/Projec... 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.

[v-chuncz-msft]

@Mahi_12,

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_12]

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