Forum Discussion
Power Bi capacity getting overloaded
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....
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.
Indeed, why multiple Date-Time columns! do you need them all ? also the best practice to use Date-Time columns is by splitting them into Date and Time columns. and again get rid of non necessary columns.
Concerning web page embedinghttps://learn.microsoft.com/en-us/power-bi/fundamentals/power-bi-browsers