Forum Discussion

Niki_33's avatar
Niki_33
Frequent Visitor
2 years ago

Power BI Audit Log

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 hist...
Need Help
Niki_33's avatar
Niki_33
Frequent Visitor
2 years ago

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's avatar
    lbendlin
    Super User
    2 years ago

    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.