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 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.)"

 

 

Need Help

3 Replies

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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