Data Flows-getting past connection settings

hi spencer_II 

Based on my research, your File path or URL is wrong.

it should like this format:

C:\Users\linli\Desktop\xxx\xxxx\xxxx\New Microsoft Excel Worksheet.xlsx

Not your path  C:\Work\Analysis\Pwr BI Monthly

By the way, for local file, you need to add a new datasource in manage gateway like below:

And when you add this datasource, please don't enable Skip Test Connnection that make sure you could have a test this datasource.

https://radacad.com/the-power-bi-gateway-all-you-need-to-know

Regards,

Lin