Attempting to create Historical Data Table

Look for appending queries. You can either 1. generate daily data to be stored on an OneDrive or Sharepoint, then import it in PowerBI, then append the new query to the existing one or 2. via Direct Query perhaps (never done it though).

hi Anonymous 

The data being fed into Power BI is the data from the source. If your data doesn't have the records from beyond 30 days then Power BI won't have it as well.  That being said, you must build a source that has the data you need. Alternatively, if you're in a Fabric SKU you can use dataflow Gen2 that allows data to be appended to the result of the previous runs  instead of replacing them but for your use case and for a very simple table, I would just build that historical source data.