Can´t Get Power BI Service to Refresh Local Data

[karimk]

Hi everybody,
I can´t seem to refresh the data of the report I published to Power BI Service. I´m not a Pro user.
The Excel files are in my local company´s server. I installed the personal gateway (the only option available to me), it shows as online, but I can´t connect the gateway to the excel files. Everytime I click on "Data Gateway" in the Downloads button I´m taken to the Power BI website explaining the use of the gateway.
Anyone can help? Below are some pics:

[Seth_C_Bauer · Accepted solution]

@karimk It appears you just need to edit the credentials to the files. Fix that, and you should be able to schedule the refresh. The fact that the option is selected and online means it is ready to go, you just need to fix the creds.

[karimk]

Thanks for the reply.

I click on edit credentials and what I get is: "Path" is greyed out and my only authentication option is "WindowsWithoutImpersonation". If I click ok, I get a message that my data was refreshed and all seems ok, but I still can´t manage my data gateways in the download button.

[Anonymous]

@karimk,

Do mask sensitive data when uploading screenshots.

Do you mean that you can't manage gateway as shown in the following screenshot? If so, it is a expected behavior, only when you install and configure on-premises gateway, you are able to manage it in the screenshot.


When you install on-premises gateway(personal mode), directly enter passwords for data sources as Eno1978's post.

Regards,
Lydia