To successfully refresh a Power Query connection, verify that all data sources included in the connection are properly configured. ...

To successfully refresh a Power Query connection, verify that all data sources included in the connection are properly configured.  Once you save a Power Query connection, each data source will have its own entry to the data source page.  Data sources other than SQL Server and Oracle can only be refreshed from within a Power Query connection.