Forum Discussion
Last access date and time
Does anyone know of a way to get the last access date and time for reports or workspaces in Power BI service?
4 Replies
- GilbertQSuper User
Hey Greg_Deckler
I would think that the Audit logs would let you know who accessed a report when? You could then get the max datetime from the audit log for each of the reports?
- Greg_DecklerCommunity Champion
GilbertQ Yeah, I know how to do that but audit logs only go back 6 months. So all you can really say is that nobody has access a report in the last 6 months. I was hoping there was some metadata on a report or workspace that would be last access time that could be exposed via the service API's.
- GilbertQSuper User
Ahh ok that makes sense. I guess that is why it is important to keep the audit log history.
I dont know of any other way to get it via an API
- blopez11Super User
There is the getunusedartifacts rest api call. You'd have to loop through the workspaces and it return items that haven't been used in the last 30 days, along with their last access date. At least that is what the documentation says. I haven't tried. I'd be interested if you find a solution as well.
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-unused-artifacts-as-admin