Power BI Report Automation

I have an existing set of online data that deliver raw activity data; what I need is a fully automated reporting flow built with Power Query and surfaced in Power BI. The goal is simple: every time the API refreshes, I want to see up-to-date visualisations that break down enablement hours and core hours without any manual intervention. A lot of manual work is done in excel all has to be removed to one refresh button.

Here is what a successful delivery will look like:

• Robust Power Query script that authenticates against the API, handles pagination or rate limits if they exist, and lands clean, well-typed tables.
• A Power BI model with meaningful relationships, calculated columns or DAX measures as needed to surface enablement hours and core hours clearly.
• At least one interactive report page that lets me slice those metrics by date, team, or any other dimensions exposed by the source.
• Refresh configured (gateway or cloud) so the report updates on schedule without me touching it.
• A short hand-off note explaining parameters, credentials, and how to extend the model if new fields are added to the API.

When you reply, please point me to past work that shows you have already automated reports from online APIs using Power Query or Power BI. Screenshots, public dashboards, or code snippets are all welcome—whatever best proves you can hit the ground running.