Find out who is using Dataflows

[joshua1990]

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?

[Anonymous · Accepted solution]

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.

[RiverChime]

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

[joshua1990]

@RiverChime : I want to know who is consuming the Dataflow. Thanks a lot!

[RiverChime]

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