pbi api refresh internal service error

[Anonymous]

Hi there!

we are using pbi api to refresh our oracle dataset through gateway. this morning we have so many report refresh failed with the same error.

Something went wrong
Refresh failed:

ops-nice has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

Technical Information

Activity Id:
00000000-0000-0000-0000-000000000000

Request Id:
7d0effa9-d870-4b95-8d43-13c30552de68

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

Refresh Start Time:
October 4, 2021 14:18 UTC

Refresh End Time:
October 4, 2021 14:18 UTC

 Could anyone give us the hint what exact error we had this morning? 

BTW, after manually refresh those dataset is good.

[bumasl]

good day

I am getting the same problem, I have not been able to update my data, I am using DATA GATEWAY
can someone guide me to solve this problem?
Thank you so much

Last wrong update: Thu Oct 07 2021 09:43:24 GMT-0500 (Central Daylight Time)
The last update attempt could not be made due to an internal service error. It is usually a temporary problem. If you try again later and you still see this message, please contact technical support
Cluster URI: WABI-PAAS-1-SCUS-redirect.analysis.windows.net

Activity ID: d0a8b66b-47f0-4e7d-8405-fb98f3bcf216

Request ID: 51baea11-b523-4872-c1aa-450f2df87784

Time: 2021-10-07 14:43:24Z

[Anonymous]

if you are admin. please check your capacity usage in admin portal -> capcity sth

[bumasl]

I'm on the screen where you mention, I don't see anything, my account is Pro

[Anonymous]

only pbi admin can see this page. if you cannot see please contact your pbi admin. this is unrelated to pro account or not

[bumasl]

the change has to be done from my web portal or in Power BI Descktop
from what I see it is for Premium account, my account is PRO

[Anonymous]

I do have follow up question regarding this issue. Our memory usage is good. only CPU usage will  spike in each morning. I suppose cpu usage is not related to how big the dataset is and it is only related to how many dataset refresh at the same time. Is my assumption correct? If my assumption is correct, the only thing we can do is reschedule those reports in different time or we need to upgrade to P2 capacity.

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

Your understanding is almost correct. What I want to add is that CPU usage is also related to the number of reports currently being used and users, because it also involves refresh (DQ) or RLS, etc.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[Anonymous]

I also checked our CPU capacity usage this morning. I found capacity reached peak in this morning.

my questions is that there is any way we can see cpu usage of sepcific dataset so we can identify which report cause this issue?

[v-janeyg-msft]

Hi, @Anonymous 

If you are the administrator, You can go to the admin portal to find out which datasets are refreshed in the corresponding time period based on this point. You can also check the refresh status of each dataset here.

Usually, Capacity overload won't be caused by the refresh of one single dataset. I suggest you set the schedule refresh in different time periods to avoid overload. 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey