Forum Discussion
Super UserFabric Capacity - Interactive Query by "Power BI Service" User
Hello,lbendlin ,thanks for your concern about this issue.Your answer is excellent!
And I would like to share some additional solutions below.
Hi,vivien57 .I am glad to help you.
It looks like you have detected an Interaction Time Range table. There is a record of a User:Power BI Service interaction that is taking longer to execute. And this is also in line with your idea.
URL:
Understand the metrics app timepoint page - Microsoft Fabric | Microsoft Learn
Based on the documentation, I think User:Power BI Service should indicate that the system is taking a long time to perform some preprocessing tasks before performing the specific user interaction.
You can continue to monitor and check which report/dashboard is monitoring such long time records during the interaction.
Perhaps it needs to be optimized (data source/data type/DAX Code, etc.)
URL:
Fabric operations - Microsoft Fabric | Microsoft Learn
There are a number of software programs that can help you monitor your reports at runtime (such as DAX Studio), and I hope you find the link below helpful.
URL:
Solved: real size of data model - Microsoft Fabric Community
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian
Super UserHello Anonymous
Thank you very much for your reply.
I don't think it's a report performance problem, because otherwise most of the user reports on this report would be affected. This is not the case, because the report is very fast (when the process mentioned is not triggered).
However, here we're in a case where PowerBI itself triggers a process, so I think it would be relevant to know what causes this process to be triggered, when it's triggered, and so on.
Do you have this information?
Thank you in advance for your return,
Have a nice day,
Vivien
Hi,vivien57 .Thank you for your reply.
Based on your description, the user's report access experience only deteriorates when the “User:Power BI Service” command record is executed. I don't have a firm idea on this for now, I think it might have something to do with the capacity usage at the time, perhaps too many resources requested at the same moment causing the system to lag.
You could create a Microsoft Support ticket to get more detailed information and check which user actions are causing this logging (time of day, number of users accessing the report at the same time, etc).
The Link of Power BI Support:Microsoft Fabric Support and Status | Microsoft Fabric
- vivien57
Hello Anonymous ,
Thank you for your feedback.
I think that before opening a ticket it would be relevant to know what triggers an action from the ‘Power BI Service’ user. I imagine that the MS teams are able to answer this, without monitoring our capacity.
What's more, as lbendlin mentioned just below, it seems that there's already a ticket on this subject.
Can you check? Confirm that it will be resolved shortly?
Thank in advance for your return,
Have a nice day,
VivienHi,vivien57 .Thank you for your reply.
I found a similar known issue, where the User:Power BI Service is a record triggered by a user republishing a large semantic model in Power BI Service.
The development team's answer to this is tentatively “by design”, and they mention that:"In general, Power BI service as user name column is expected, even for interactive query".
I noticed that your item kind = Dataset, the problem may be related to the user manipulating the dataset.
You need to crate a Mcirosoft Supprot to get more detailed informationMicrosoft Fabric Support and Status | Microsoft Fabric
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian