Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
nandic
Super User
Super User

Fabric capacity metrics - who is the owner of specific item?

Hi,

Earlier, we used premium capacity. Now, we usefabric capacity. I am fabric capacity admin. 
Today i was checking capacity and saw that there are couple of items within someone's "My workspace", which use old (expired) premium capacity.

I went to admin portal > workspaces and saw that all personal workspaces belong to old premium capacity. So i "moved" all to fabric capacity.

However, is there any possibility to find who is the owner of specific item?
I don't have access to personal workspace, but as fabric capacity admin, i suppose there should be a nice way to find who is consuming resources and to contact that person to disable/pause, or if it is for production, to move it to shared workspace.

Is there a way to get information who is the owner of specific item?

nandic_0-1762246424687.png

 

In addition, if it is using P2 capacity which expired, how it even works? I expected some errors, notifications... but no, it works, refreshes data, like everything is normal?

Thanks in advance,
Nemanja

1 ACCEPTED SOLUTION
tayloramy
Community Champion
Community Champion

Hi @nandic

 

I don't think you can use a script to add yourself to all personal workspaces, and you very much don't want to. If you have two users with the same name, you will end up with access to two workspaces with the same name, and that breaks everything (at least it did when I accidently added myself to two personal workspaces for users that had the same name) 

 

If you drill through in Capacity Metrics to the timepoint details, you should be able to see the user ID that ran the item

 

Does this work for you? 

For example, I can see all thse eventstreams that I am the user for: 

tayloramy_0-1762273955564.png

 


If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

View solution in original post

6 REPLIES 6
nandic
Super User
Super User

@tayloramy thank you, that solved the issue!
Easier than expected.
Earlier i was drilling to timepoint details, but for this specific case nothing was shown there. However, when i changed to "logarithmic" view, values were shown and i could drill to a user level.

Thank you very much!

tayloramy
Community Champion
Community Champion

Glad I could help. 

 

Capacity Metrics is a very useful tool 🙂

The real time capacity metrics events that are scheduled for public preview according to the roadmap are also very useful tools, can't wait until we can actually talk about it. 

 

nandic
Super User
Super User

Hi @AntoineW  and @tayloramy ,

Thank you for your suggestions. 
In admin portal i can give myself permission to user's "My Workspace", but there are hundreds of users in the company.

And my main issue is to see which user is using this item in his/her workspace.

If i run power shell script to go over each workspace and find this specific item, it returns only results for workspaces i have access to.

So possible steps would be:
1) grant myself permissions to all personal workspaces (via script if possible) and then search in which one is this specific item
2) remove myself from all personal workspaces except mine (via script if possible)

Alternative, send email to all users, asking who is using this item 🙂 

Hope to test this in a few days. 

Cheers,
Nemanja

tayloramy
Community Champion
Community Champion

Hi @nandic

 

I don't think you can use a script to add yourself to all personal workspaces, and you very much don't want to. If you have two users with the same name, you will end up with access to two workspaces with the same name, and that breaks everything (at least it did when I accidently added myself to two personal workspaces for users that had the same name) 

 

If you drill through in Capacity Metrics to the timepoint details, you should be able to see the user ID that ran the item

 

Does this work for you? 

For example, I can see all thse eventstreams that I am the user for: 

tayloramy_0-1762273955564.png

 


If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

tayloramy
Community Champion
Community Champion

Hi @nandic

 

The best way to see who the owner is would be with the admin APIs. Try Items - Get Item - REST API (Admin) | Microsoft Learn

 

Also, if you are the Fabric Administrator, you can grant yourself access to personal workspaces as @AntoineW mentioned above. IF you're only the Capacity Administrator however, you won't be able to do that. 

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

 

AntoineW
Memorable Member
Memorable Member

Yes, in the portal admin, you have the workspace rubric at the left panel, select it and if you click on each personal workspaces, you can find who has access by clicling on "Get Access".

 

AntoineW_0-1762249337946.png

 

Hope it can help you!

Best regards,

Antoine

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.