Data Source Connection based on Parameters to switch between cloud and local sources possible?

As it turns out, unfortunately, it looks like using an "if" statement to dictate the source within a query makes you lose the ability to refresh the dataset once published to the cloud.

Though everything works perfectly on the desktop, once the dataset is published, the service doesn't recognize the data source as being valid within the query, and therefore doesn't give you any options for refresh or editing credentials.

I tried writing the query your proposed way with the "if" statement outside of the source line as well as my method where the source line includes the if statement within it and both methods fail in the cloud.

So I think in reality what I want seems to be impossible.