PowerPivot for SharePoint 2016 Scheduled Data Refresh Error: “The operation has timed out”

UPDATE: 4/25/17: PowerShell to increase timeout included in workaround section. Scenario: You create a PowerPivot workbook with one or more data sources and upload it to SharePoint 2016. You then schedule the workbook to refresh and the refresh fails with the following error: “The operation has timed out”. Cause: This issue is caused by a…

4