What is the best practice for pulling data out of SAP Subscription Billing for Reporting Needs

I have a requirement to create some custom reports using data available in SAP Subscription Billing. I investigated using Excel's Power Query to call the Subscription Billing APIs but there is a limitation in Power Query in terms of reading the API Repsonse Header information which is vital to know how many request will be needed to fetch all the desired data. Is there a recommended best practice (tool or process) for pulling data from Subscription Billing for reporting purposes?

Thank you,