I have a query on a Dashboard file housed in SharePoint folder. Data source is in another folder also in SharePoint.
I am unable to refresh Dashboard since I get below errors (also see screen shots):
Query and Refresh Data: Be careful. The query to get the data might be unsafe so you should only refresh the workbook if you trust its source.
External Data Refresh Failed: We were unable to refresh one or more data connections in this workbook.
The following connections failed to refresh:
Does anyone know a work around?
Bookmarks