Microsoft SharePoint 2013 Excel Services & External Data Refresh Failed Message

Microsoft SharePoint 2013 Excel Services - External Data Refresh Failed Message

Here is that scary message:

External Data Refresh Failed

An error occurred while working on the Data Model in the workbook.

Please try again.

We were unable to refresh one or more data connections in this workbook.

The following connections failed to refresh:

Content Query Web Part – SharePoint 2013

Content Query Web Part – SharePoint 2013

The Content Query Web Part allows you to display content from anywhere in your site collection with your choice of filtration, grouping and styling; it’s a handy web part for rolling up content to a Dashboard or creating an Archive view of content.

The Content Query Web Part is generally used to display  a list based on certain criteria by user where the List Type, List Content and Additional Filters help you generate a view with less effort and time.