Storing data source credentials times out

Question

I'm experiencing&nbsp;the following problem:&nbsp;- We created an Azure SQL database and put some dummy data in.&nbsp;- In Power BI Desktop we add the data source and create a sample report.&nbsp;- We publish to Power BI service.&nbsp;- In the browser, we can look at the report. But when we try to refresh the data source, it tells us that our credentials are wrong.&nbsp;- Now, when I try to enter the credentials, nothing happens for many minutes and it appears to time out.&nbsp;&nbsp;&nbsp;Does anyone have an idea for what could be causing this issue?

anonymous · Answer

Hi&nbsp;hellopath,
Can you please share more detail information&nbsp;to help us clarify your scenario, please refer to below link:
&nbsp;
Troubleshooting the On-premises data gateway
&nbsp;
Spoiler (Highlight to read)
Tools for troubleshooting

Collecting logs from the gateway configurator
There are several logs you can collect for the gateway, and you should always start with the logs. The simplest way to collect logs after installing the gateway is through the user interface. In the&nbsp;On-premises data gateway&nbsp;user interface, select&nbsp;Diagnostics&nbsp;and then select the&nbsp;Export logs&nbsp;link near the bottom of the page, as shown in the following image.

Installer logs
Copy
%localappdata%\Temp\On-premises_data_gateway_*.log

Configuration logs
Copy
%localappdata%\Microsoft\On-premises Data Gateway\GatewayConfigurator*.log

On-premises data gateway service logs
Copy
C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises Data Gateway\Gateway*.log

Event Logs
The&nbsp;On-premises data gateway service&nbsp;event logs are present under&nbsp;Application and Services Logs.

Fiddler Trace
Fiddler&nbsp;is a free tool from Telerik that monitors HTTP traffic. You can see the back and forth with the Power BI service from the client machine. This may show errors and other related information.

Refresh History
When using the gateway for scheduled refresh,&nbsp;Refresh History&nbsp;can help you see what errors have occurred, as well as provide useful data if you should need to create a support request. You can view both scheduled, as well as on demand, refreshes. Here is how you can get to the&nbsp;Refresh History.

In the Power BI navigation pane, in&nbsp;Datasets, select a dataset &gt; Open Menu &gt;&nbsp;Schedule Refresh.

In&nbsp;Settings for...&nbsp;&gt;&nbsp;Schedule Refresh, select&nbsp;Refresh History.

Tools for troubleshooting