Forum Discussion
Helper IReport Snapshot/Freeze Data Scenario
Community SupportHi archerjayden ,
You may need to install and configure the gateway to display data normally, since your SQL Server data database is a kind of on premise data source .Then you may add the data source to that gateway. See more: :On-premises data gateway , Add a data source. Finally , you may disable the scheduled refresh for the dataset in this way.
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.
Helper IHi 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
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.