Forum Discussion
Solved
Database Refreshing
HI, I had a PowerBI with SQL query direct import ( I copy and pasted the query), everytime I make any changes, it refresh the query and I often get error message saying the SELECT permission was...
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.
Thank you!!