Forum Discussion
Power BI Refresh user
Hello.
Is it possible to get the user who refreshes a dataset via the REST API or audit logs.
We have several semantic models, dataflows (And a few datamarts) that connect to data sources usings employee accounts. Then an employee leaves and the refresh breaks.
I want to monitor which semantic models, dataflows are connected and refreshing as an employee account so i can take action and switch these over to service accounts before said user leaves.
Thanks
2 Replies
Per the documentation, the REST API doesn't include that information on the Get Refresh History: (https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history)
On the audit logs you can see who are the owners of the dataset though, but they aren't necessarily always the ones who trigger a refresh. I've never been a tenant admin to specifically tell you if you can get case-by-case refresh details but perhaps lbendlin can chime in.
This should get you going Introducing the Power BI Activity Log | Microsoft Power BI Blog | Microsoft Power BI
But what you really want is this: Power BI implementation planning: Tenant-level auditing - Power BI | Microsoft Learn
and specifically
Get-PowerBIActivityEvent -StartDateTime 2021-09-30T00:00:00 -EndDateTime 2021-09-30T05:59:59 -ActivityType 'RefreshDataset';
