Forum Discussion
Find out who is using Dataflows
Hi experts!
I am the owner / admin of a PBI workspace that contains some dataflows.
Now I would like to do some changes in the dataflow.
Is there any chance to determine who is using the dataflows?
Hi joshua1990 ,
You can do this in the Admin portal – Audit logs – Go to Microsoft 365 Admin Center.
Go to the Microsoft 365 Admin Center interface and find Audit
You can search for dataflow on it, and information about dataflow will appear, such as Retrieved Power BI dataflow users , Retrieved Power BI dataflow for user, etc.
Refer to:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing#use-the-audit-log
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
If you mean who is editing it, I am not sure we have visibility on that
If you mean what is using the dataflows, you can View Lineage
If you want to know who own it, you can see the owner from the Owner field, or you may select Setting to find out who was the last editor, and even take over from there
RiverChime : I want to know who is consuming the Dataflow. Thanks a lot!
Dataflow is not final product and cannot be used directly by user. It is usually used as linked table by other dataflow or dataset. Users consume reports which is a bit further downstream.
The normal relationship is Data Source > Dataflow (Power Query/M) > Dataset (Power Pivot/Data Model/DAX/Relationship) > Report/Paginated Report/Dashboard (Power View/Visuals) > Users
The best solution for your scenario will probably be tracing the downstream components using Lineage, and list all the users consuming all the reports. Those are the users consuming the dataflow
Hi joshua1990 ,
You can do this in the Admin portal – Audit logs – Go to Microsoft 365 Admin Center.
Go to the Microsoft 365 Admin Center interface and find Audit
You can search for dataflow on it, and information about dataflow will appear, such as Retrieved Power BI dataflow users , Retrieved Power BI dataflow for user, etc.
Refer to:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing#use-the-audit-log
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
