Live Tracking User Metrics Using Power BI

Summer.B

Hello smartsheet Community,

I want to track company smartsheet user metrics such as the number of users, number of sheets, user types, etc. automatically using Power BI. Currently, I am exporting the user and sheet access reports and having to combine them into a single view before displaying the data in a meaningful way. I have already connected Power BI to Smartsheet, but currently, the only user metrics I'm receiving are my own. Is it possible to have these metrics for the company live feed? 

Thank you. 

Andrée Starå

Hi Summer,

This might help: https://help.smartsheet.com/articles/2479296-event-reporting-monitor-how-data-is-used-across-your-organization

Also, if you haven’t already, I would recommend that you reach out to the Smartsheet Support Team to hear what's possible. Smartsheet Support Team

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD