Report Snapshot/Freeze Data Scenario

Hi, Does anyone have work around to take monthly or bi weekly reports snapshot of PowerBI Report which is based off SQL Server On Prem Direct Query mode. User wants to lockdown the last period data ...