PowerBI on Fabric get stuck
Hi All, We recently migrated from PowerBI Premium to F64 capacity on Fabric. Here on fabric we are facing challenge on capacity Utilization. It has been observed that a single user can consume more than 200% of entire capacity. Therefore all other users are getting stuck and no reports run during that time. Also there is no option to kill the user session on fabric to reclaim the capacity for other users. This is really pathetic. Also it doesnt provide the session logs to see which report which is creating such problem. I haven't seen this in other products where no feature to get the session logs and admin the user sessions. Below is the workaround provided by MS support team which is ridiculous. "We have checked with our internal team regarding the automatic session termination for a specific user. Unfortunately, they have confirmed that this feature is not feasible at the moment. However, there are alternative steps you can take to address the issue. You can identify the datasets and workspaces causing the problem and reassign them to different capacities or remove the access of the user consuming excessive capacity." It would be greate help is someone can provide the workaround or possible solution for this problem. Thanks