Synapse, Pipelines & Integration runtimes!

[Anonymous]

Hi All,

I want to build a power bi report that shows all the pipeline runs, health and other connected servers all together.

Does anyone know how to get this out of Synapse?

Thanks

Andy

[refex]

Try with azure rest api, you may need to add some intermediate layer in between

Pipeline Run - REST API (Azure Synapse) | Microsoft Docs

[v-eqin-msft]

Hi @Anonymous ,

Could you please mark your reply as the solution to make the thread closed?

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Anonymous ,

It seems that you have resolved the issue. If so ,please kindly Accept it as the solution. More people will benefit from it.😀

Best Regards,
Eyelyn Qin

[Anonymous]

I believe you can get more hints from this official document:

Pipeline outcome summary for all pipelines sample report - Azure DevOps | Microsoft Docs

I think this is the wrong type of pipeline but thanks for the document

[v-eqin-msft]

Hi @Anonymous ,

According to my understanding, you may want to see pipeline metrics for all the pipelines together in a single report.

I believe you can get more hints from this official document:

Pipeline outcome summary for all pipelines sample report - Azure DevOps | Microsoft Docs

Refer to:

https://techcommunity.microsoft.com/t5/azure-synapse-analytics/integrate-power-bi-with-azure-synapse-analytics/ba-p/2003057

https://www.be-terna.com/sites/5ebfc39e232fb906a3dfc34b/assets/5f3fb90d232fb95d6db09df0/power-bi-professionals-guide-to-azure-synapse-analytics_2020_06.pdf

https://www.wintellect.com/how-azure-synapse-integrates-your-data-pipelines/

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

[Anonymous]

Hi,

When you use Synapse there is a 'Monitor' section and you can see the data pipeline runs its this that i want to monitor in power bi.
Thanks

Andy