SSIS Replication Log Dashboard 02-22-2019 21:58 PM - last edited 02-23-2019 13:51 PM

[Anonymous]

I inspired by @stretcharm before working on this dashboard. He has a great Dashboard of SSIS catalog here. There couldn't be alternative work of him then i decided to make dashboard of my custom logs. And this dashboard showed up.

This Replication log dashboard tells story about execution log of SSIS packages. Gives easy read availability about all past activities and show Master and child packages as a hierarchy with count of execution and average of running duration. Also shows how many rows loaded per tables by SSIS packages.

I have 2 basic log templates.  If you like it and want to use, you need to download at least log tables from github. https://github.com/macnr/SSIS-Packages

eyJrIjoiYmExY2U1ODUtNDA0OS00YjFmLWE3NzktYWRjMTZiZGQyZWFhIiwidCI6ImViZGJlZmExLWU0NmMtNDkzYi05NzNlLWVjZjgxNTgwNmEwYiIsImMiOjl9

[stretcharm]

Good to see someone else doing ssis dashboarding in PowerBI.

It's a fantastic tool for support type monitoring dashboards especially if you have them scheduled on the PowerBI Report Server.

Check out my SSIS dashboard https://community.powerbi.com/t5/Data-Stories-Gallery/SSIS-Catalog-DB-Dashboard/td-p/244677

[Anonymous]

Hi @stretcharm , i have published this dashboard in lack of time last night but after your comment i notice, i  didn't mention about you. Because your SSIS Catalog DB Dashboard inspired me to build my first public Power BI Dashboard. Thanks a lot for your work, your comment and like.

[stretcharm]

Thanks.

Yes lets make our lives easier. PowerBI is not just for our users or customers 🙂