I think the part that a bunch of us (myself included) were missing was adding the workbook to the PowerBI Workspace and then going under Settings and Workbooks and assigning the gateway to that workbook.  That is what tells the excel file where to actually look for it's refreshes!

 

Now the question is, how can other users also refresh or are we at the mercy of the scheduled refreshes under my PowerBI User???  Currently we get an error when another user tries to refresh the pivot table...  

 

Thanks

www.000webhost.com