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

[harikagokaram]

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 4, Error: The remote server returned an error: (404) Not Found. (The resource cannot be found.)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (The resource cannot be found.)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (The resource cannot be found.)"

[V-pazhen-msft]

@harikagokaram 

(404) error meaning there is no data received, or the source is removed or not exist. Please recheck the source make sure it has no problem to connect.

Regards
Paul

[PhilipTreacy]

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]

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