Forum Discussion

SunilKumar123's avatar
SunilKumar123
Frequent Visitor
5 years ago

powerbi/refresh/subscribe - what does this query request do ?

While doing a performance test using J-Meter, we found that this particular query request: powerbi/refresh/subscribe is recording longer times around 120 seconds. We investigated and found that time is getting recorded for this query request even after all the visuals on the screen are loaded. Can anyone help in understanding what this particular query exactly does and can we optimize  this or is this a PBI default one.  One more information is that PBI is connected to SSAS cube here.

6 Replies

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support

    Hi SunilKumar123,


    Have you tried other tools such as Analyze performance, Dax studio etc?

    Do they also contain the same query?

    Maybe I haven't come across it, or I haven't get which query you're describing.

    Providing more details would help tremendously.

     

    Best Regards,

    Link

     

     

     

    • SunilKumar123's avatar
      SunilKumar123
      Frequent Visitor

      Thanks for the reply. Please find our response below

      1. We have conducted performance test using J-meter on published screens(on Powerbi service). We could use performance analyzer only on Power BI file service and not on publsihed screens right.

      2. Steps followed to conduct test manually:

      1. On published screens, we did F12 to inspect elements
      2. Go to Network tab, you can see various requests and time is getting recorded for their execution
      3. Among all the requests, this particular request:/powerbi/refresh/subscribe is either taking longer time or getting cancelled after sometime
      4. We observed a similar query even in other PowerBi tools and thought that this might be a default PowerBi thing to create a connection between PowerBI tool & server.

      Please provide a resposne and let us know if more details are required.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi,
        facing the same issue, how can we turn this off. in my case both track and subscribe calls are taking a lot of time.

        wabi-us-east2-b-primary-redirect.analysis.windows.net/powerbi/refresh/subscribe taking at least 30 seconds and mostly fail. it also block other requests and delays report/dashboard rendering.

         



  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,
    facing the same issue, how can we turn this off. in my case both track and subscribe calls are taking a lot of time.

    wabi-us-east2-b-primary-redirect.analysis.windows.net/powerbi/refresh/subscribe taking at least 30 seconds and mostly fail. it also block other requests and delays report/dashboard rendering.

     



  • Just wondering if anyone has a solution to this problem?  Is there a way to stop the call to subscribe happening when the report is embedded?

  • Anonymous's avatar
    Anonymous
    Not applicable

    When using React Suspense 'subscribe' and 'track' requests will make app inaccessible