Forum Discussion
Super UserFabric Capacity - Interactive Query by "Power BI Service" User
Hello everyone,
Do you know what an interactive request from the ‘Power BI Service’ user is (red line)?
This seems to be triggered on the basis of a user action (yellow line), but blocks the latter until it is completed and as you can see this can be quite long, so a bad user experience.
Thanks in advance for your feedback,
Vivien
15 Replies
- lbendlin
We have a ticket open with Microsoft for this since March 2024. Allegedly this will supposedly maybe be fixed by end of January 2025. What a disgrace.
- vivien57
Thank you very much for your feedback lbendlin .
What information did they give you ? Which way is it going to be resolved? This query will no longer exist, so there won't be any blocking before accessing the report?
Did you also create a post on the Fabric forum beforehand? If so, can you send me the link?
Thanks again
- lbendlin
The consumables will be distributed to their rightful owners, so that we finally know who to contact to have a friendly discussion about over-usage.
The fix is allegedly still on track for "mid January 2025". I'll believe it when I see it. There are other adjacent issues like a "System" user popping up randomly, and the user for Dataflow Gen2 refreshes having extra <euii></euii> tags.
If you dare look at the semantic model behind the app you get the idea that is is a very half-baked and rather unprofessional effort on Microsoft's side. Not even mentioning the 8 minute delay here 🙂
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- vivien57
Hello 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,
VivienHi,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
