For example, for Azure SQL server you also see the database name. On the data source cards, you see more information that can help identify the source. You see the data sources from which the datasets and dataflows get their data. In this view, you see all the workspace artifacts and how the data flows from one artifact to another. Tap the arrow next to List view and select Lineage view. To access lineage view, go to the workspace list view. See Permissions in this article for details. You need at least a Contributor role in the workspace to view it. Explore lineage viewĮvery workspace automatically has a lineage view. This video might use earlier versions of Power BI Desktop or the Power BI service. It shows connections between all workspace artifacts, including connections to dataflows, both upstream and downstream. In lineage view, you see the lineage relationships between all the artifacts in a workspace, and all its external dependencies. For complex projects and for simpler ones, we introduce lineage view. External data sources and datasets make it harder to know where the data is coming from, ultimately. When a dataset is external to a workspace you own, it may be in a workspace owned by someone in IT or another analyst. Many datasets and dataflows connect to external data sources such as SQL Server, and to external datasets in other workspaces. Power BI has several artifact types, such as dashboards, reports, datasets, and dataflows.

Power BI's data lineage view helps you answer these questions. They may require a team of experts or deep investigation to understand. Questions like 'What happens if I change this data?' or 'Why isn't this report up to date?' can be hard to answer. The challenge is even bigger if you have built advanced analytical projects spanning multiple data sources, artifacts, and dependencies. In modern business intelligence (BI) projects, understanding the flow of data from the data source to its destination can be a challenge.

Lineage w not available in your country