Power BI Audit Log

[Niki_33]

Hi,

We are ingesting Power BI Log data in a Databrick WH via call Rest API. And, connect Power BI desktop to it to monitor User activities and have statistics on the artifacts, too. We have all history of UserEventActivities, But, on the level of existing or removed artifacts, we can't confirm data stored in Databrick. Issue can be in Databrick call Rest API (how the experts configured data collection in WH. They Get-PowerBIWorkspaces and then Get-PowerBIReports, Datasets,... by looping on the WorkspacesIDs, then add recoreds daily to the DimReports. ) or our model in Power BI after connecting to it (we defined Activities as Fact table and Reports, Datasets, Workspaces,... as dimensions).

Is there any complete reference on it? I searched on the web, but did not succeed to find the answers. It would be appreciated if you share your experience with me.

[Niki_33]

Hi,

Yes, I have Jsons of activties and csv of artifacts exports (cmdLet extractions) for my archives. But, our official data is stored automatically in our cloud WH.

I have 2 principal questions:

1- the data model. What is the best/commen model? We want to have a view on the users activites and the statistics on our artifacts(how many worspaces or reports based on date,...)

2- the data collection in cloud via Rest API. How to retrive Get-PowerBIReports? on a daily basis, we get the snapshot of existing reports (Get-PowerBIReports) and save recodes.  But, I can't recognise if a report is deleted or not. Because it adds new existing reports and I see all the reports existing now and existed before in a workspace without their status. 

Thank you so much for your time!

[lbendlin]

Deletions have their own audit API calls.

As for the data model - whatever works for you. Having the raw data saved away is much more important.

[lbendlin]

Not clear what your issue is here. Can you elaborate a bit more?  I hope you saved the JSON exports in a reliable location.