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 and publish it to broader group. There is one APP which is already live that is available to all users and power user wants to take a copy on last date of last period and be able to lockdown/freeze the data within report. Please advise how best to approach this
My Approach: I have suggested to convert to Import Mode and publish to dev workspace and then copy this report over to desired prod workspace so they will not have option to refresh on dataset. Warned the user not to click on Dataset refresh. Is there a way to disable the Dataset refresh completely ?
Thanks in Advance