title: An error occurred while working on the Data Model in the workbook. Please try again
body: <p>I use <code>SharePoint 2013</code> and I use BI web site in SharePoint.</p>
  
  <p>I Configured <code>Power Pivot Service</code> in SharePoint 2013.</p>
  
  <p>I upload my excel file that contain Power Pivot report.</p>
  
  <p>When I open my Excel file in Share point document and select <code>Refresh Selected Connection</code> from <code>Data</code> menu, </p>
  
  <p><img src="https://i.stack.imgur.com/ygfSm.png" alt="enter image description here"></p>
  
  <p>I get this error :</p>
  
  <p><img src="https://i.stack.imgur.com/AUcuJ.png" alt="enter image description here"></p>
  
  <pre><code>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: 
  </code></pre>
  
  <p>I set my <code>SSS ID</code> in <code>Excel Services Authentication Settings</code> in my excel report.</p>
  
  <p><img src="https://i.stack.imgur.com/mTx45.png" alt="enter image description here"></p>
  
  <p>And I configure my <code>SSS</code> like this : </p>
  
  <p><img src="https://i.stack.imgur.com/Tse4K.png" alt="enter image description here">
  <img src="https://i.stack.imgur.com/hb3bR.png" alt="enter image description here">
  <img src="https://i.stack.imgur.com/PG14i.png" alt="enter image description here"></p>
  
  <p>I Found this link <a href="http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2013/04/02/3550012.aspx" rel="nofollow noreferrer">PowerPivot 2013 for SharePoint - "External Data Refresh Failed" using Interactive Data Refresh via "Use the authenticated user's account"</a> but it not work in my case.</p>