Forum Discussion
Database Refreshing
You can disable the 'include in report refresh' of the data in Power BI desktop whilst you're doing your dev work, through Power Query Editor, and right clicking on your tables:
And when you're ready to publish I would enable load, and then set up a scheduled refresh to automate the data refresh each month.
Hi James,
Thank you for the reply. I sorry for the confusing terminology. I used Import ( i called it direct import, my apology). I just import and load the data yesterday, and now I want transform data and add another column, but I received a datasource Error because our IT is refreshing the database and not allow us to access the database. The data I loaded yesterday will not change until next month, so there is no need for me to refresh the data anyways. I am wondering how do I stop the refresh until next month.
Thank you
You can disable the 'include in report refresh' of the data in Power BI desktop whilst you're doing your dev work, through Power Query Editor, and right clicking on your tables:
And when you're ready to publish I would enable load, and then set up a scheduled refresh to automate the data refresh each month.