Newbee - Get API's and Export data

Hi Guys, please forgive me in advance if these questions are very basic. I am completely new to API’s and Postman so I’m seeking advice. My role is MI and Reporting so I normally query SQL databases in order to pull data for reporting purposes. This is normally done through Power BI. I have a few questions if that’s ok:

  1. Is there a way to use Postman to export the results from the API into a usable format for Power BI, ie, CSV file etc.
  2. With regards to question 1, can this been done automatically so you do not have to run the get requests on a daily basis.
  3. Are there any limits to the about of rows you can export from Postman.

Many thanks