Refresh Failed - I need explanation of error details

[JasonMcKenney]

Hello,

I am receiving refresh failure notices on one of my datasets and I'm having trouble finding the cause based on the error message I'm receiving:

Activity Id: f4e68e90-8846-4630-a134-cefa25fff97f

Request Id: de6962d2-be1c-4a71-94e6-839c095c7867

Cluster Name: WABI-US-EAST2-redirect.analysis.windows.net

Refresh Start Time: 06/27/2017 04:05:20Z

Refresh End Time: 06/27/2017 06:19:16Z

Has anyone else seen a similar error? My company gateway is running properly and I'm not seeing any specific errors for missing columns or data. My other datasets are refreshing fine. Is there a time limit on data refreshes? This particular data set takes a couple of hours.

[acanepa]

Hello @JasonMcKenney

I had similar problems with Power BI service a couple days ago, I didn't know what it was the problem so I raised a ticket.

The fix was basically to upgrade the enterprise gateway,  that for my own surprise is upgraded constantly, once per month.

The fix worked instantly for all the dashboard that were failing consistently in schedule refresh and on-demand refresh.

Hope it helps.

Regards,

[Seth_C_Bauer]

@JasonMcKenney It could be timing out. Check the gateway logs to see if you can determine any additional information.

https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-tshoot/

Tools for troubleshooting

Collecting logs from the gateway configurator

There are several logs you can collect for the gateway. Always start with the logs!

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