Forum Discussion
PowerQuery: only refresh if parameter is set to True, otherwise don't refresh
Thanks for the suggestions! The dataflows suggestion would work, but the problem is that it would be more complex to create and maintain than my current solution (Run the query on our database, copy the results to an "enter data" table in powerBI). I was hoping to eradicate the manual steps. Because we serve many different clients, we would need to create a dataflow for each of them, hurting the maintainability of the data flows, which, as far as I can tell, I cannot copy between workspaces.
But thanks a lot for thinking along though! Guess I'm still waiting for the day Power BI service actually listens to the "include in report refresh" tick :(
Make sure to leave your vote here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20579641-exclude-a-table-from-refresh-in-power-bi-service