Forum Discussion

Marco57's avatar
Marco57
Icon for Helper III rankHelper III
5 years ago

The session was cancelled because it exceeded a timeout setting or memory limit - Premium Capacity

Hello,

 

I have a dropdown querying few lines (really a dozain of lines) and very frequently I get the visual failing with below error:

 

I checked memory usage metrics on capacity and it is just fine, multiple gigas left.

 

The visual is failing after 1 second from the trigger click so it is not query timeout issue as it is set to around 3 mins by default.

 

The issue gets solved only after restarting the premium capacity so it defintely looks like related to session idle or something but I found no documentation at all on this. I am embedding this report within a web application.

 

Did anyone face such issue or would have a clue?

 

Thanks

Rgds

Marc.

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  Marco57 ,

    This may be related to your data volume and loading speed. Here are some optimization methods you can try:

    1. Optimizing Premium capacities.

    https://docs.microsoft.com/en-us/power-bi/admin/service-premium-capacity-optimize

    2. In Power Query you can keep the "Enable load" of the first table, and disable the "Enable load" of the remaining tables.

    https://community.powerbi.com/t5/Service/Power-BI-service-could-not-load-the-data-properly/m-p/1208234

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Marco57's avatar
      Marco57
      Icon for Helper III rankHelper III
      5 years ago

      Thanks for your answer Anonymous 

       

      I am not sure it is linked to this as I am using DirectQuery for few lines of data ...

      There is no enable or not enable when using DirectQuery.

       

      Issue is intermittent.

       

      Thanks

      Regards

      Marc.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  Marco57 ,

     

    Will Power BI Desktop report the same problem? You can check whether the Dax used in the Visual that reports the error is wrong, and whether the measure and calculated column can be optimized.

    The Direct Query connection mode has many restrictions in Power BI. You can check whether the link touches which restriction and the data is not loaded.

    For example, Performance and load, the database is complex and the back-end source response time is too long, there's a one-million-row limit for cloud sources, etc.

    https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#limitations-of-directquery

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.