Auto Refresh Disabled in Power Service due to Error

That's probably not the static table. If by static you mean that table has data entered in manually then there should be no data source to be configured. I have several tables like that and never have any issue. Maybe some connection requires to re-enter the credentials? Anyway you can open the gateway settings in the dataset settings page, it should tell you which connection is missing.