Data source for network drive using on-premises gateway

AFoulk,

How do you connect to these files in Power BI Desktop? If you use Excel connector in Power BI Desktop to connect to  your files, please follow the guide in this similar thread to add all the Excel data sources within gateway.

However, if you use Folder connector in Power BI Desktop to connnect to your files, please add data source within gateway using Folder option.

Regards,
Lydia

After speaking some more with our IT Manager, the problem was the link address. I was using the drive letter with the path following but it needed to begin with our server name first so it was the full technical path.

The worked for the gateway, then I discovered I had to update all of my individual sources accessing that drive to change to that full path as I had went in through "My Computer" and what I needed to do was actually paste the same path listed in the gateway. Now everything work and presents the ability to schedule refresh.

Super thrilled that is all squared away now!