Refresh Odata Query on Published reports.

[bideveloper555]

hi,

Below is odate query from microsoft website.

i was able to refresh on my desktop but i cant refresh on web service.

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/sample-boards-sprintburndown?view=azure...

i have 2 connections on one report.

1.https://analytics.dev.azure.com/xxxx/xxxxx/_odata/v3.0-preview/      (full dataset from devops)

2. from above link, o data query.

my report data are able to refresh for first connection(full dataset) but not microsoft odata query.

can any one help how to refresh above microsoft odata on web service(power bi).

what am i missing.

FYI: On-premises data gateway is installed . my report refresh works but i can only see report updated from full data set devops but not microsoft odata query.

thanks

Vinay

[v-eachen-msft]

Hi @bideveloper555 ,

Your Odata is online, after publishing to Power BI Service, you don't need to set it in gateway connection.

You need to set it in Data source credentials, just select the dataset->setting->refresh->configure credentials.

[bideveloper555]

hi,

my refresh works with out error but there is no data on charts.

when i refresh on desktop,i can see data on charts.

thanks

Vinay

[bideveloper555]

can you please help me to convert belo query into table.

Source:  https://docs.microsoft.com/en-us/azure/devops/report/powerbi/sample-boards-sprintburndown?view=azure...

let Source = OData.Feed ("https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/WorkItemSnapshot? " &"$apply=filter( " &"WorkItemType eq 'User Story' " &"and startswith(Area/AreaPath,'{areapath}') " &"and StateCategory ne 'Completed' " &"and DateValue ge Iteration/StartDate " &"and DateValue le Iteration/EndDate " &"and Iteration/StartDate le now() " &"and Iteration/EndDate ge now() " &") " &"/groupby( " &"(DateValue,State,WorkItemType,Priority,Area/AreaPath,Iteration/IterationPath), " &"aggregate($count as Count, StoryPoints with sum as TotalStoryPoints) " &") " ,null, [Implementation="2.0",OmitValues = ODataOmitValues.Nulls,ODataVersion = 4]) in Source