Forum Discussion
Solved
Query for Dataflow usage by others
How can I query a dataflow as it is being used by other users, such as refresher records in powerbi desktop or excel?
Thanks all,
I think my question is not clear, I need to know who uses the dataflow I published,
I've found a way to do it and share it with you:
1: Enter the "Admin monitoring" workspace in Fabric, view the "Analysis" in the "Feature Usage and Adoption" report, and roughly understand the usage of each user by filtering the used user activities.This pertains to whether the account holds administrative privileges.
2: Through the Microsoft audit log to view，https://purview.microsoft.com/
Hello Dageda,
If you're a Power BI Admin, you can access the Power BI Audit Logs to track when users query or refresh a Dataflow.
Alternatively, the Power BI REST API allows you to check Dataflow refresh history, including who triggered the refresh.
GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows/{dataflowId}/refreshes
{
"value": [
{
"id": "refresh12345",
"startTime": "2024-02-05T12:00:00Z",
"endTime": "2024-02-05T12:10:00Z",
"refreshType": "Scheduled",
"status": "Completed",
"servicePrincipal": "[email protected]"
}
]
}