Query refresh fail

%3CLINGO-SUB%20id%3D%22lingo-sub-2226202%22%20slang%3D%22en-US%22%3EQuery%20refresh%20fail%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2226202%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22x-hidden-focus%22%3EI%20have%20a%20query%20Dashboard%20file%20housed%20in%20a%20SharePoint%20folder.%20Data%20source%20is%20in%20another%20folder%20also%20in%20SharePoint.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20am%20unable%20to%20refresh%20Dashboard.....encounter%20below%20errors%20%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CEM%3EQuery%20and%20Refresh%20Data%3A%20Be%20careful.%20The%20query%20to%20get%20the%20data%20might%20be%20unsafe%20so%20you%20should%20only%20refresh%20the%20workbook%20if%20you%20trust%20its%20source.%3CBR%20%2F%3E%3CBR%20%2F%3EExternal%20Data%20Refresh%20Failed%3A%20We%20were%20unable%20to%20refresh%20one%20or%20more%20data%20connections%20in%20this%20workbook.%3CBR%20%2F%3EThe%20following%20connections%20failed%20to%20refresh%3A%3C%2FEM%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EDoes%20anyone%20know%20a%20work%20around%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2226202%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

I have a query Dashboard file housed in a SharePoint folder. Data source is in another folder also in SharePoint.

I am unable to refresh Dashboard.....encounter below errors :

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?

0 Replies