Build PowerBI dashboard with servicenow operation ticket data

to build a power bi dashboard with info like-Ticket aging, days since last update, created age bucket, update age bucket, total tickets, sla breached, sla percentage , tickets older than 3/5/7 days without update, tickets by manager, ticket by resolver group, I already have this kind of report pulling data from excel but I want fully automated using API from servicenow

Contract duration of less than 1 month. with 30 hours per week.

Mandatory skills: Microsoft Power BI, Microsoft Power BI Data Visualization