11 thoughts on “Dataflows in Power BI: Overview Part 9 – Lineage and impact analysis

  1. Pingback: Dataflows in Power BI – BI Polar

  2. Marcus Early

    The data lineage developments are exciting. A large portion of our datasets come from views in SQL/oracle or SAP queries, both of which will have transformations prior to the dataflow lineage path, I believe. I’m really hoping the development plans will in the future provide:
    -visibility to a builder consuming dataflows to see the lineage from the dataflow connector in power bi desktop. that would help the builder know the lineage path at the time needed rather than have them open the workspace to review
    -visibility to the models/builds that take advantage of this dataflow. To me, that is currently where we are somewhat lacking in visibility. “If I change this dataflow, which models are about to fail refresh?”


    1. That second hope is one of the capabilities shown in the MBAS video this post references. I can’t wait until there’s an internal environment available for me to start kicking the tires…


  3. Hi Mathew, great post. We need to be able to track lineage of dataflows the other way i.e. which datasets are they being used in, from which workspace. Similar into how we can track the lineage of datasets across workspaces/reports/dashboards. This helps to manage the sharing of data across different teams/departments. The lineage features coming look good.


    1. Thanks Lee – I definitely agree that there’s a need for comprehensive end-to-end lineage. We showed off some demos of workspace-level lineage at MBAS in June, and I’ve been playing with some of the preview capabilities since then. I think you’ll be pretty happy once they’re more broadly available.

      Although I’ll have to deprecate this post…;-)


  4. Pingback: Governing Power BI just got a little easier – BI Polar

  5. Pingback: Power BI workspace lineage – BI Polar

  6. Quentin

    It seems that this option is no longer available with the new interface of PowerBi service. The lineage between dataflow and dataset and not shown any more…
    Is there a simple way to view the connections of dataset to dataflow?


      1. Quentin

        Thanks Metthew,
        Unfortunatly i’m still incapable of viewing a lineage between a dataflow and the dataset created after importation in a report…
        We’ll look deeper into it and try to see where i get things wrong…


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s