Forum Discussion

Helper I

6 years ago

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 ...

Helper I

6 years ago

Hi v-xicai,

Yes the data source for SQL Server is already added to EnterPrise Gateway and we are on premium.

The goal here is to hold stagnant data in PowerBI Service. Yes we have turned off Scheduled Refresh

If a user clicks on Dataset refresh by accident or unknowingly then latest data will flow into the report. We want to avoid this so looking for an approach where we can block users from doing this who also happend to be admin of workspace. Please advise?

Thanks,

Archer

v-xicai

Community Support

6 years ago

Hi archerjayden ,

Your demand is a good idea, while there is no such an option to lock refresh in Power BI currently. You can post your new idea in Idea Forum , add your comments there to improve Power BI and make this feature coming sooner.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Report Snapshot/Freeze Data Scenario

Related content

Paginated Report with SELECTEDVALUE scenarios

Data Filter Scenario

Scenario mapping table

Actuals and forecasts - scenarios

Azure Analysis Service Migration Scenarios