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
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

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

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

    Yeah wow, that makes a world of difference. Complete disaster if you don't do it. 

     

    • 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 

        After you switch or delete datasource in Power bi desktop, please republish the report to Power bi service and replace th original one.

        In Power bi service, delete the original data source under gateway.

        Add new source undre the gateway and configure refresh settings.

         

        Best Regards

        Maggie