Power BI Custom API Setup

I need a straightforward way to pull live data from a specific website into Power BI for my established business. The goal is to set up our own API connection so I can build clear, up-to-date visualizations without manual downloads.

Here’s what I’m after:
• Build a basic, reliable API connector that fetches the required data from the site.
• Configure the connection in Power BI Desktop (and show me where to enter credentials or headers if needed).
• Deliver a sample report that proves the data refreshes correctly and can be expanded into future visuals.
• Provide a short, plain-language setup guide so I can replicate the steps on another workstation.

If you have experience integrating web services or REST APIs into Power BI and can keep the solution clean and well-documented, I’d love to work with you.