Failed to parse gateway core config file: Object reference not set to an instance of an object.

[Anonymous]

I am seeing these errors in my gateway. I am not sure if they are the reason my datasets are failing to refresh or not. 

Failed to parse gateway core config file: Object reference not set to an instance of an object.

I followed the instructions here: https://docs.microsoft.com/en-us/power-bi/service-gateway-proxy#changing-the-gateway-service-account...

However, this didn't fix my issues. Does anyone have any further advice?

[v-shex-msft]

HI @Anonymous,

I'm not so clarify for your scenario, can you please provide more detailed information about your issue?

Troubleshooting the on-premises data gateway

Spoiler

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 logslink 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 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.

1. In the Power BI navigation pane, in Datasets, select a dataset > Open Menu > Schedule Refresh.

   

2. In Settings for... > Schedule Refresh, select Refresh History.

   

   

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

I ended up opening a ticket and the reponse was to look into the network/firewall at loosing connection or maintenance at this same time. I found out that our firewall was getting reboot during this time. This was causing the reports to fail the refresh.