Forum Discussion
Storing data source credentials times out
Hi hellopath,
Can you please share more detail information to help us clarify your scenario, please refer to below link:
Troubleshooting the On-premises data gateway
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 On-premises data gateway user interface, select Diagnostics and then select the Export logs link near the bottom of the page, as shown in the following image.
Installer logs
%localappdata%\Temp\On-premises_data_gateway_*.log
Configuration logs
%localappdata%\Microsoft\On-premises Data Gateway\GatewayConfigurator*.log
On-premises data gateway service logs
C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises Data Gateway\Gateway*.log
Event Logs
The On-premises data gateway service event logs are present under Application and Services Logs.
Fiddler Trace
Fiddler 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, Refresh History 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 Refresh History.
-
In the Power BI navigation pane, in Datasets, select a dataset > Open Menu > Schedule Refresh.
-
In Settings for... > Schedule Refresh, select Refresh History.
Regards,
Xiaoxin Sheng
- hellopath8 years agoRegular Visitor
Hello and thanks!
We're not using the On-premises data gateway. As mentioned in the On-premises data gateway FAQ , the gateway is not required for Azure SQL Database.
- Anonymous8 years agoNot applicable
Hi hellopath,
I can update credentials on my side, maybe you can submit a support ticket with trace session (signin credential) as detailed contents.
submit a support ticket
Regards,
Xiaoxin Sheng- hellopath8 years agoRegular Visitor
Hi and thanks! I have already created a support ticket. So far we're still looking for a solution.