Forum Discussion

YogeshPersiste's avatar
YogeshPersiste
New Member
2 years ago

Power Bi capacity getting overloaded

Hi,

 

I am using P1 capacity and on this capacity workspace, one report is published report size is 10MB approx on workspace.

When a user uses this report it is utilizing 80% of my capacity. when I check in the Capacity metric (fabric app) it shows interactive operation "query" is causing an overload of capacity usage. This is due only to this report.

This report does not have complex Dax formulas. total data rows are 700000 approx.

This report has RLS implemented and cross-region user is accessing this report.

 

Please help me on this.!!!!!!

 

 

Need Help

3 Replies

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi YogeshPersiste 

    Simply optimise your report. DAX is not the only reason, relationships between tables could be the cause, Bidirectional could be the cause, unecessary columns like DateTime could be the cause.... 

    • YogeshPersiste's avatar
      YogeshPersiste
      New Member
      2 years ago

      Hi AJ1973,

       

      In this file I have only one table used, it has a multiple Date time column. There is one Datetime calculated column which is using convert funtion.

      This report is embeded on web page and the user are viewing this on web application also.

      Some user using this report on Power BI services. When user interacting on Power BI service the Capacity metrics report shows operation Query which is using 12+% CPU usage.