How to use APIs as a data source?

Hi HarrisonBi 

Firstly, which kind of Rest API do you want to use? Just like Power BI, different applications and portals has their own API. If you want to connect to your portal by Rest API in Power BI Desktop, you need to make sure your portal support Rest API. You can try Web connector to connect Rest API in Power BI Desktop. 

For Reference: Using a REST API as a data source

Your data source is in cloud, I think you just need to set data credentials in dataset setting in Power BI Service for schedule refresh. 

Did you mean that when you get your table from API, you will have a row limitation?

Which kind of method did you use to call API, POST or Get?

Rest API may have some limitations: Power BI REST API limitations

You can try to use List.Numbers along with Skip or Offset in the web calls to overcome the row limit. 

This video walks through it.

Power BI - Tales From The Front - REST APIs - YouTube

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.