analytics.dev.azure.com pipelines runs missing data

[Anonymous]

Hi everyone!

I want to use info about pipelines from analytics.dev.azure.com in Power BI Report.

I use odata connection and code presented on Microsoft docs website.

When I use this link  

https://analytics.dev.azure.com/{mycompany}/{myproject}/_odata/v3.0-preview/PipelineRuns?

 I see only 5 pipelines. 

When I open ADO and this project's pipelines, I see many more pipeline runs.

I changed odata version from 3.0_preview to 3.0 or 4.0_preview, no difference in results.

What could be the problem?

[Anonymous]

Hi Caitlyn!

Thanks for additional questions.

1) I have not noticed this before because I have just recently started on ingesting data from ADO pipelines into Power BI Report.

2) What I do in Power Query: I use odata connection to ingest data about pipelines and pipelines runs (based on queries provided on MS docs website). I see for example 5 pipelines and their runs (no date filter).

3) What I see in ADO pipelines: when I open pipelines and runs tab, I see many more runs.

Maybe in ADO runs all tab there are also deleted pipelines runs presented?

How can I differentiate active pipeline from deleted pipeline in ADO pipelines?

[Anonymous]

Hi @Anonymous ,

Did this situation come out of nowhere? Have you had similar problems before?

I'm not quite sure if I understand your needs accurately. Would you mind telling me a more detailed description of your needs so that I can help you better?

If I have not understood your needs correctly, please do not hesitate to inform me.

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.