Fabric Capacity - Interactive Query by "Power BI Service" User

[vivien57]

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

[Anonymous]

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,

Vivien

[Anonymous]

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,

Vivien

[Anonymous]

Hi,@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 information

Microsoft 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

[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 🙂

[vivien57]

Hello @lbendlin,

Have you had any news? Do you still have the problem on your side?

Thank in advance for your return,

Have a nice day,

Vivien

[lbendlin]

This is my latest status update.  Not instilling much confidence.

This fix is part of a major update due on the next 2-3 weeks.

There are some parts of the update that are still being tested.

[vivien57]

Hello @lbendlin,

I noticed this problem again yesterday (05 February)

If you have any new information, don't hesitate to let us know.

Have a nice day,

Vivien

[lbendlin]

I have been told " in February". They have not mentioned the year...

[vivien57]

Hello @lbendlin 

Have you had any news? Do you still have the problem on your side?

Thank in advance for your return,

Have a nice day,

[lbendlin]

On March 19 we held a big birthday party. Our ticket is now more than a year old, and the way things going we will likely celebrate the second birthday too.

I strongly dislike Microsoft's cavalier attitude towards the monetary impact this has on our business.

[vivien57]

Hello @lbendlin ,

Thank you for your feedback. When you have an official validation of the correction, could you please keep us informed here?

Thank you in advance for your help,

Have a nice day,

Vivien