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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
M-IMS
Regular Visitor

Audit Logs don't have all the information

Hi, was trying to get audit logs and it doesn't have everything.

 

for example it doesn't have when a refresh happens (like scheduled refresh)

and I'm pretty sure it doesn't have all the info.

I tried to get from purview and Get-PowerBIActivityEvent and both missing datapoints

 

also the new usage report isn't refreshing even though admin of power bi workspace (I even have access to admin monitoring)

 

MIMS_1-1741362086015.png

 

7 REPLIES 7
mariussve1
Super User
Super User

Hi again,

 

Saying that you, as a pro user, can’t use the API is incorrect—but as you mentioned, you’ve already tested it yourself.

 

There are no restrictions in that regard, but some API endpoints are designed for capacity reasons, so those won’t work.

 

I’m not aware of any single endpoint that contains absolutely everything, so you’ll likely need to combine multiple APIs. But as I said, there’s a lot of cool things you can build by pulling data from the API, storing it in your data warehouse, and then connecting everything together. Personally, I’ve created a large admin package that ties it all together, giving me full oversight of all users—who does what, which jobs are running, and what fails.

 

As I mentioned, I also use Log Analytics for even more detailed logs. I’ve also used the Graph API for Azure to include license information, last login times, password changes, and so on.

 

The only real limit is your imagination.

 

If you find my answers helpful and think they could help others, I’d really appreciate it if you marked it as the accepted solution.


Br
Marius
BI Fabrikken
www.bifabrikken.no
mariussve1
Super User
Super User

Hi,

 

The ActivityEvents does not have scheduled refresh, that is correct. It has more which user interact in what way with Fabric ( view report, Edit report, connects with Excel etc ).

 

But Power BI have tons of apis you can use for diffrent use cases.

 

To get refresh log you can use:

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history-in-group

Or you can look at this admin api:

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-refreshables-for-capacity

Im using Fabric pipeline to fetch data from multiple api and stored it in Warehouse. Then I have created a admin semantic model with all of the insight. You Can Even use this to trigger apis with power Automate. Works really nice.

 

I have also enabled Log Analytics on my workspaces. That gives you a lot of details the apis does not provide. That is also something you could look into.


Br
Marius
BI Fabrikken
www.bifabrikken.no

We're on Pro License not fabric since we don't need the any extra features.

Is there an endpoint that have EVERYTHING related to PBI?

 

I did look into log analytics few weeks ago and sadly it is only allowed to premium.

There is nothing you can do when you are on a Pro license.

there is, I can call the endpoint myself.

but I'm also interested in potential limitation, since docs don't really say much.

lbendlin
Super User
Super User

Sorry to hear that. Do you have a question?

Yes why doesn't audit logs have all records.

Helpful resources

Announcements