Save Historical Data from QuickBooks Online In Power BI

Hi All,

We are trying to create a weekly trend report in Power BI using data from Quickbooks Online. The Quickbooks Online only gives access to certain types of tables. The data we are pulling does not has historical data it is refreshed in Quickbooks Online on a daily basis. We need to pull this data on a weekly basis from QuickBooks and save it it Power BI for each week we pull from QuickBooks so we have historical data available in Power BI to do the weekly trend report. If we just use the data from the Quickbooks connecter it will override the data in the Power BI. What is the best way to approach this so we can save the data each time we pull (on a weekly basis) and use that to create weekly trend report on the fly. 

thank you for your feedback.