What is Lineage View in Power BI?

BUSINESS INTELLIGENCE.

Lineage view is a feature within the Power BI Service which gives a single relational view of all the data and visual building blocks of the Power BI workspace.

This enables better management, troubleshooting, and impact analysis in the flow of data from the initial data source to the end user dashboard.

In modern analytics applications, understanding the flow of data from data source to the end report can be a challenge. In more complex implementations with multiple data sources, dependencies, and reports, it is an even greater challenge, especially when troubleshooting or understanding the impact of a change. Historically these data flows and dependencies would be documented and updated using external tools. 

The Lineage View in Power BI Service is an easily accessible relational view of all of the building blocks of your Power BI solution for a particular Workspace. It is a comprehensive graphical representation of the data flows and dependencies from:

 

  • Data Sources – Excel, SQL Server, or online services.
  • Dataflows – online store of data sources.
  • Datasets – data store and model for a report.
  • Reports – visual application.
  • Dashboards – combination of pinned visuals from reports.

Lineage view also allows you to do the following:

 

  • Search for a particular Power BI building block.
  • Quickly access more options for the dataset, report, or dashboard.
  • Refresh datasets and dataflows and display refresh status.
  • Quantify the impact of a specific data source or dataset over multiple workspaces, reports, and dashboards.
  • Send notifications to contacts regarding a specific data source.

Application

When would you use the Lineage View in Power BI?

 

  • To gain an overall view of the data dependencies for a specific Power BI report.
  • To troubleshoot data refresh issues by viewing the refresh status of dependent dataflows and datasets.
  • To identify the impact of making a change to a data source or dataset over multiple workspaces.
  • To notify each workspace contact list of issues or changes affecting a data source or dataset.

Business Intelligence Staffing Software

Streamline your decision making with business analytics and business intelligence.

More from 1Staff by Professional Advantage

Unmistakable signs your business is ready for a Modern MSP

Unmistakable signs your business is ready for a Modern MSP

Pre-pandemic, your business could operate with most of your employees working inside the four corners of your office, and your IT managed service provider (MSP) focused more on monitoring and securing your network, servers, and desktops.

Are you a slave to your SmartList?

Are you a slave to your SmartList?

SmartLists are a powerful tool in Microsoft Dynamics GP. Their ability to take you straight in to the detail you require, and export to Excel for further filtering, is a powerful aid to users, and very popular.

Azure Virtual Desktop Cheat Sheet

Azure Virtual Desktop Cheat Sheet

CLOUD AND INFRASTRUCTURE. Azure Virtual Desktop Cheat Sheet. A closer look at a desktop and application virtualization solution.Azure Virtual Desktop (AVD). What it's about and why it matters.Remote working is now part of the default workstyle for most organisations....

About 1Staff Staffing Software?

1Staff is the leading staffing software and recruitment solution that fully leverages the Microsoft Dynamics platform

1Staff Front Office is built on the Microsoft Dynamics 365 and Power Platform and will help your sales people find and service clients, help your recruiters manage candidates and fill jobs quicker and help your compliance team drive efficiencies and de-risk the onboarding process.

 

1Staff Back Office is built on Microsoft Dynamics GP, a powerful pay/bill and financial (GL/AR/AP) system. 1Staff Back Office will help your workforce capture their time, help finance smooth the pay/bill process and help the executive control and grow the business.

1Staff Analytics & Planning underpinned by Microsoft Power BI delivers extensive analytics, role-based dashboards plus budgeting forecasting and scenario planning