Can't uncheck Include in Report Refresh when data source is not available
A website I normally pull data from has temporarily removed the table I was refreshing data from, but is working on fixing. Before I used to just uncheck "Include in report refesh" from Transform Data. However, it will not Apply this because it keeps circling back and saying it can't connect to that source. I know, that's why I'm trying to turn off! I don't want to delete and I want to keep the most recent data it had, just don't want to refresh until they fix.
Why can't I turn it off when the data source is not available?? Help, please!?!
thank you @themistoklis , you're right, that would be a work around, just unfortunate that I'd lose all my Applied Steps were doing from the previous sources - replacing values, etc. but may have to, just don't understand why can't turn off refresh temporarily when a source isn't available and it says can't because not available - which I know which is why I want to turn off, it just leaves you in a horrible circular issue! Thank you for the work around though
thank you @amitchandak I had hoped that was going to resolve it, but even after disabling background refresh, when try to Apply Query Changes it says table not found, which I know which is why trying to turn off "Include in report refresh" temporarily 😞
actually @amitchandak this appears to have done it if I just keep ignoring the trying to Apply, I can now hit Refresh and the rest of the data sets refresh so I can post. I just have to say Apply Later and ignore it trying to do anything to that data table. Thank you!