Create a dataset and report on audit log using api - store history audit logs

[SukhijaVishal]

Hello,

I see audit logs are APIs are available, referring to documentation page:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing

Is there a way to query this api in Power BI Desktop app, or create a dataflow for this with admin credentials? Tried doing this but getting below error:

The requirement is to be able to keep the an year's audit logs for external audit requirements, which will show the changes done in a particular worspace reports, and deployments done via deployment pipelines. As audit logs are available only for 3 months, we want to store this permanently somewhere, preferably in power bi dataset.

Thanks, 

Vishal

[v-cazheng-msft]

Hi @SukhijaVishal ,

You may refer to this blog: https://community.powerbi.com/t5/Community-Blog/How-to-view-the-frequency-of-user-usage-for-all-work.... Just as the blog said, you could use the Power BI API (Beta) custom connector to build reports based on data retrieved by Power BI REST API. After published the report to Power BI service, you will get the expected dataset.

Best Regards,

Community Support Team _ Caiyun

[SukhijaVishal]

Thank you for the response.

I was able to find correct documentation and correct api to access audit logs for deployment pipeline:

https://docs.microsoft.com/en-us/rest/api/power-bi/pipelines/get-pipeline-operations

One issue I face now is the logs do not show id of the person who did deployment. This is crutial piece of information required. Any way this can be included in the api response? below is the api response from web as well as in desktop app:

Thanks,

Vishal