Forum Discussion

harikagokaram's avatar
harikagokaram
Regular Visitor
5 years ago

Getting error while trying to use a Powerbi query or O data query

Hi,   I am getting below error while using a powerbi/odata query in powerbi, please help   Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: OData Version: 3 and...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi harikagokaram 

A 404 means whatever you are requesting wasn't found at the remote machine.

What exactly are you trying to get?  Can you share the query?

Phil

harikagokaram's avatar
harikagokaram
Regular Visitor
5 years ago

Hi,

 

I am trying out the below query to build a report using test plan

 

let
Source = OData.Feed ("https://analytics.dev.azure.com/{raboweb-ftbtr}/{FtBtR}/_odata/v3.0-preview/TestPoints?"
&"$apply=filter(( TestSuite/TestPlanTitle eq '{GAMMA MVP 2-E2E / MVP AT}' ))"
&"/aggregate("
&"$count as TotalCount,"
&"cast(LastResultOutcome eq 'Passed', Edm.Int32) with sum as Passed,"
&"cast(LastResultOutcome eq 'Failed', Edm.Int32) with sum as Failed,"
&"cast(LastResultOutcome eq 'Blocked', Edm.Int32) with sum as Blocked,"
&"cast(LastResultOutcome eq 'NotApplicable', Edm.Int32) with sum as NotApplicable,"
&"cast(LastResultOutcome eq 'None', Edm.Int32) with sum as NotExecuted,"
&"cast(LastResultOutcome ne 'None', Edm.Int32) with sum as Executed"
&")/compute("
&"Executed mul 100 div TotalCount as ExecPct,"
&"iif(TotalCount gt NotExecuted, Passed mul 100 div Executed,0) as PassedPct"
&")", null, [Implementation="2.0"])
in
Source