Forum Discussion

joglidden2's avatar
joglidden2
Icon for Post Patron rankPost Patron
6 years ago

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 Serv...
General Comment
Need Help
Tips and Tricks
joglidden2's avatar
joglidden2
Icon for Post Patron rankPost Patron
6 years ago

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. 

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi joglidden2 

You could refer to my first reply.

since your old database don't use any more, so first switch into import and disable refresh for the table which connecting to the database.

thus when refreshing, it won't update any data from the old database and as it was imported into power bi already, the data is stored inside power bi.

 

Best Regards

Maggie

  • joglidden2's avatar
    joglidden2
    Icon for Post Patron rankPost Patron
    6 years ago

    v-juanli-msft  Maggie, ok, I did all that. I also went in to the service and switched off refresh (it was still set to refresh, even after I switched the report to 'Import' and republished). Anyway, it's off now. 

     

    I'm going to give it another month before I delete to the datasource, just in case something goes wrong. I'm hoping by then the people who wanted to keep the reports lose interest so I don't have to recreate it all. 

     

    Thanks again for the reply.