cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bhanes22
Helper I
Helper I

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? Screenshot 2.PNGScreenshot1.PNG

1 ACCEPTED SOLUTION
bhanes22
Helper I
Helper I

Not sure what changed, but deleted the data sources from the gateway cluster and remade them exactly as I did before and it started working.

View solution in original post

4 REPLIES 4
bhanes22
Helper I
Helper I

Not sure what changed, but deleted the data sources from the gateway cluster and remade them exactly as I did before and it started working.

View solution in original post

Thanks for letting us know!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @bhanes22 


Can you confirm that your file has got the right permissions for the account on your On-Premise server?

 

What I mean by that is if you right click on the file on your Gateway Server and select Properties and then click on Security does your account have read access to this file?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Yes I do have the correct permissions for this file - full control. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!