Build me a balance Scorecard in Power BI linked to B2Wise and Other internal reporting systems

I have implemented a Balanced Scored for KPI monitoring in my manufacturing unit which currently is manually updated. I would like the BSC which is formatted in excel to be automatically updated from the various reporting which are available on our internal system. I would like the BSC to be displayed in Power BI