The last refresh attempt failed because of an internal service error

[enablejulian]

Hi

I'm getting the following error on a scheduled refresh. I have refreshed in power bi desktop and republished no problem. I have checked the authentication when resetting the schedule refresh with no problems. But a basic refresh online causes this error to occur.

My data is from dynamics CRM and sharepoint excel.

The last refresh attempt failed because of an internal service error.
Please try again later or contact support. If you contact support, please provide these details.

Cluster URIWABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net

Activity IDe648e4b6-6c48-49e7-8521-3c2d6e251028

Request ID4d059649-cd58-c4e4-d05e-abb0c36eb95d

Time2018-03-25 05:09:47Z

Can anyone point me in the right direction?

Julian

[v-yulgu-msft]

Hi @enablejulian,

Since there existing multiple different data source types in your report dataset, did you configure data gateway for each of them?

Regards,

Yuliana Gu

[enablejulian]

Hi Yuliana, @v-yulgu-msft

I am not using on premises data gateway 

I have put in my credentials and it appears to work, but the schedule refresh doesn't happen. This dataset had been working for several months without problem.

Julian

[kcantor · Accepted solution]

@enablejulian

Sometimes there is just a hiccup in the system. I have had this happen occasionally. Some times it clears up on its own. Other times I end up doing a republish.

never have gotten a clear answer from Microsoft. 

the most persistent error did come from cloud based data, though. Once PowerBI seemed to lose connection with my sharepoint. Microsoft had to step in on that one and fix it on the back end. 

Have you tried a republish?

[enablejulian]

Apology for delayed response - this issue has been resolved, but we do see it happen occassionally (usually about once a month). Unfortunately it happened on a day of an important data review, so there was a lot of scrambling to get rectified.

As a longer term solution we are looking at tidying up our dataset to see if this issue becomes less persistent

[enablejulian]

HI @kcantor

Yes, have done refresh and republish from power bi desktop. Am attempting to log a ticket with Microsoft now.

[Anonymous]

Hei @enablejulian , 

I had the same problem, did you figure something out? 

Thanks! 

[hmorven]

did you got any answer about it? @Anonymous