Forum Discussion
Switch to import, delete database
A general question, and I'm soliciting opinions about what may happen. Consider the following:
I have some reports, published to a workspace, and the data source for the reports is Azure SQL Server database. I need to delete this database, because it is no longer used. However, I need the reports to continue to function in the workspace, with the last data that was in the database before I deleted it.
So my idea is to switch all the tables in the reports from storage mode 'Direct Query' to 'Import', refresh the report data, save the report, republish to the workspace, and then delete the database. Will this work? Will the reports continue to function on the last "cached" data from the database before I deleted it? Any opinions or advice on this scenario would be appreciated.
6 Replies
Hi joglidden2
Your idea can work.
If you create reports using power bi desktop, you could convert directquery into import in Power bi desktop.
in Power query, right click on the table name, uncheck "include in report refresh", then this table would not be refreshed when you refresh the dataset in power bi desktop or power bi service.
Best Regards
Maggie
Yeah wow, that makes a world of difference. Complete disaster if you don't do it.
One more update... I still had to go into the service and switch off scheduled refresh for each datasource, or you will get constant emails announcing failure. Still haven't had the courage to delete the database. Will update here the results when I do.
