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