Monitor Data Pipeline

[BoNDoK01]

We have data pipelines from on-premise data sources to Power BI Service:

1. Raw data extracted from ERP systems using one SSIS package.

2. Data is transformed using another SSIS package.

3. Data is used to build a dataset in Power BI, so data travels thought gatway to reach the online report.

What is the best way to monitor such a pipeline.  Is Azure Monitor a possible solution? 

[Anonymous]

Hi @BoNDoK01 ,

Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.

Best Regards,

Neeko Tang

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

[Anonymous]

Hi @BoNDoK01 ,

Azure SQL Database Auditing logs tracks database events, enabling you to retain, report and analyze the activities in the instances you monitor. 

Please refer to the following documents for more information.

Monitor your Azure SQL Database Auditing activity with Power BI | Microsoft Power BI Blog | Microsof...

Log Analytics integration with Power BI and Excel - Azure Monitor | Microsoft Learn

Monitor data factories using Azure Monitor - Azure Data Factory | Microsoft Learn

Best Regards,

Neeko Tang

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