Cannot exclude broken connections from refresh

Hi all,

I have a Power BI dashboard that draws on datasets from several sources. Our team is having trouble accessing a number of these datasets due to trouble with CRM access, so our solution has been to house data elsewhere when it requires continuous updating, but for data that does not require updating, I have just been using the historical pre-loaded data held in the PBI file from when the connection was working.

I now want to set up the queries so that clicking Refresh will only refresh the 15-20 data tables housed elsewhere while ignoring those archived files with the broken connection  -- since including these will cause the whole refresh fail like so:

To replicate this, I have attached an example file which calls on two datasets:

1. Working Connection -> local csv which connects correctly
2. Broken Connection -> local csv which initially connects correctly, but breaks due to a change in the subfolder name

LINK: https://drive.google.com/drive/folders/1TFelWa3OmuLTtI4cAnUoMe9Vvxuxw4KX?usp=sharing

NOTE: you will need to add these two datasets to the PBI file on your local device, then close the PBI file and change the subfolder name like so:

Refreshing now produces an error:

In Power Query, I had hoped that a solution to this would be to uncheck 'Include in refresh report' (as below), however I am unable to apply this change without having a working connection to begin with, leaving me unable to refresh it and unable to exclude it from refresh. Is there a workaround to resolve this?

So far the solutions I see are:

1. Turn off 'Enable load' - This will remove the whole data source from the model, breaking model connections and any visuals calling on this data (Not a solution)
2. Manually refresh each of the 15-20 functioning data tables with each update (time consuming and hard to explain to other users who are not familiar with Power BI)
3. Extract each archived data table into a csv housed in the new working location, then change the initial 'Source' step of each of these to pull from this new location. (Could work, though there are approx. 40 of these tables and I will lose the ability to revert back to the CRM connection if that connection is ever repaired)

Is there a better way here that I am not seeing? Really appreciate any help with this!

Many thanks,

Taylor