REST API data to SQL (other Azure) to PowerBi

Question

Hey There!

Were new to the world of data and need some guidance.

We looking to pull data from our whitelabel software using thier rest API and create reports in PowerBI.

We want the data to be pulled and updated every day, and our understanding is that we need to use a SQL database todo so.

However, its not entirely clear how to go about all of this, or if there is a better way?

SImply put, we have data in a Whitelabel platform that updates daily, and we want to generate reports of this data in PowerBI (which updates as the data updates, with out having to reupload CSV files).

Any guidance would be great,

Best