Tips on Using the Fabric Capacity Metrics App

This video goes through the Fabric Capacity Metrics App (version as of Jan 2024) with tips to help monitor and troubleshoot your Fabric capacity.

[@danmeiss]

Great stuff Pat. Keep them coming, these type of videos are helpful to the community.

[@carloscantu75]

Very useful tips, I use this app frequently and still got some good ideas from the scenarios you explained. Thanks for sharing!

[@hoosierbi5669]

Glad it was helpful!

[@danielsduarte]

That was really helpful! thanks for sharing.

[@mact312]

awesome information! Thank you for sharing!

[@lutzbendlin6027]

Putting the Metrics app on a Premium Capacity is counter productive, especially if it is the capacity you are monitoring.
In addition to Power Automate you can use Fabric Reflexes to be notified about exceeded thresholds. Oh, wait, never mind 😞

[@yogeshthorat732]

please share links for blog and doc

[@anjuz1255]

Hi, I'm using MS fabric trial version and now installed fabric metric capacity app. Given the trail version capacity Id while installing the app. The app installed but the report is not showing any data. Any idea why this happens?? Please reply

[@dattrieuds]

Great video! Thanks! Have you tried to find a way to store the data of this metric app to have longer history other than 14 days?

[@danmeiss]

If the app/report is in a premium capacity, you can always write DAX against it and pull out some summary tables using Semantic Link in a notebook and write the results back down to a Fabric lakehouse. There is way too much data in this (Direct Query) model to "store it all". But aggregating it, say at the time slice level, without all the specific operations detail, could be reasonable.
That is what he mentions at the very end of the video where he monitors a specific handful of parameters at some interval and passes them to Power Automate to send a notification email. That level of "pull some key points or aggregations and store it someplace" could be done with Semantic Link.