topic why is my refresh failing in Service

why is my refresh failing

MrClod — Thu, 22 Feb 2018 15:06:45 GMT

My reports were working, now scheduled and manual refreshes not working. Works fine if I refresh on desktop and publish, but not useful to be forced to do this on a daily basis.

The report has not changed.

The error details returned provide nothing but guids. Anyway to look these up?

Re: why is my refresh failing

MrClod — Thu, 22 Feb 2018 15:07:50 GMT

Re: why is my refresh failing

anirban — Thu, 22 Feb 2018 18:09:23 GMT

I am facing the same issue since yesterday. Does anyone have a clue?

Re: why is my refresh failing

v-huizhn-msft — Mon, 26 Feb 2018 03:15:53 GMT

Hi MrClod,

Please reconfigure your refresh schedule and check if it works fine.

Best Regards,
Angelia

Re: why is my refresh failing

MrClod — Mon, 26 Feb 2018 14:56:15 GMT

Not sure how "reconfiguring" refresh schedule will fix this when manual refresh fails as well.

Re: why is my refresh failing

Anonymous — Tue, 27 Feb 2018 03:10:42 GMT

What error are you getting when you look at the refresh history? The true error is usually displayed there.

Re: why is my refresh failing

MrClod — Tue, 27 Feb 2018 14:53:14 GMT

There has never been an error message provided. This was working about two weeks ago and then just stopped. No changes made. Still same data source credentials and they too show valid.

Re: why is my refresh failing

MrClod — Tue, 27 Feb 2018 15:03:32 GMT

Is there a refresh timeout? I know I am well below the data limit, but wondering if there is a time limit I am bumping against.

Re: why is my refresh failing

MrClod — Tue, 27 Feb 2018 15:09:29 GMT

Never mind, just check through all the PowerBI Failure emails, and the begin/end time duration varies from a couple of minutes to 50 minutes.

Re: why is my refresh failing

Anonymous — Tue, 27 Feb 2018 17:50:08 GMT

MrClod, what are you data sources?

Re: why is my refresh failing

MrClod — Tue, 27 Feb 2018 18:05:30 GMT

I have two data sources.

Azure sql store
Kusto

Re: why is my refresh failing

Anonymous — Tue, 27 Feb 2018 18:20:16 GMT

MrClod, are you able to create a new report with same connections and do these connections refresh?

Re: why is my refresh failing

MrClod — Tue, 27 Feb 2018 22:16:25 GMT

I just took a copy of my current report and pushed it. Failed with no error message provided.

Removed my Kusto data sources. This worked on a manual. Will setup a scheduled refresh.

But if this is the case, odd that this just now fails when it has been working for months without changes.

Re: why is my refresh failing

MrClod — Tue, 27 Feb 2018 22:44:41 GMT

I just refreshed my Kusto creds again and have a success.

Last time I did this, only worked for a day though.

Re: why is my refresh failing

v-huizhn-msft — Wed, 28 Feb 2018 00:51:40 GMT

Hi MrClod,

Please mark your reply as answer, so more people will find solution easily and quickly.

Best Regards,
Angelia

Re: why is my refresh failing

MrClod — Thu, 01 Mar 2018 17:10:14 GMT

Okay, after refreshing my credentials to Kusto for a 5th time, I guess they finally stuck.

This should have happend after the first time, so guessing there is a small PowerBI Server bug here.