title: Initialization of the data source failed - Excel 2016
body: <p>I'm trying to refresh a query in Excel 2016 (new install) and I get the above error. I've looked around, the problem seems quite common, but none of the answers seem to fit my issue.</p>
  
  <p>In Excel, I have a couple of tabs of data in Excel tables. I use Get &amp; Transform to import these tables into Power Query from where I generate 4 further tables of data, which are uploaded to the Data Model. I then create 3 relationships and generate 3 pivot tables with a single slicer to operate the tables.</p>
  
  <p>When I come out of Excel and go back in and select "Refresh All", this is when I get the error:</p>
  
  <blockquote>
    <p>Initial of the data source failed. </p>
    
    <p>Check the database server or contract your db admin. Make sure the
    external db is available and then try the operation again. If you see
    this message again, create a new data source to connect to the DB</p>
  </blockquote>
  
  <p>The data source is the excel workbook. I tried re-creating the Power Query queries etc, but to no avail. </p>
  
  <p>Repair on Power Pivot also didn't work. </p>
  
  <p>Given it's a new install of 2016, which comes with Power Query and Pivot as standard, I'm not sure where to try next. </p>
  
  <p>Any help much appreciated.</p>