Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

pbi api refresh internal service error

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.

Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    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

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      v-janeyg-msft
      Community Support
      4 years ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      v-janeyg-msft
      Community Support
      4 years ago

      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

  • bumasl's avatar
    bumasl
    Frequent Visitor
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

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

      • bumasl's avatar
        bumasl
        Frequent Visitor
        4 years ago

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