Invalid Credentials to local file using On Prem Gateway
Hi so first time using power bi so please bear with me. I have two tables tied to this dataset, one is a SQL table being pulled from SQL server via the on prem gateway and the other is a local excel table on a file stored on the same PC the on premise gateway is installed. The SQL sonncetion is fine; however, the local file connection seems to be invalid. When I go to powerbi and go to settings-> manage gateways -> new dataspurce and add this local file sonnection using my credentials (admin and user of this specific PC) I get a successful connection (See screenshot 2) but when I go to refresh it says invalid credentials (See screenshot 1) Does anyone have any idea why?