Power BI & Data Lineage?

[Anonymous]

Hi All,

I am looking for an option to be able to do some impact analysis on Power BI reports that are developed.

For example: I am having Power BI reports 1, 2 and 3. Those reports are hosted within Power BI Service.

Power BI report 1 and 2 are connected to the views Customers and Sales in our SQL DWH, to be more specific to columns A and B from the Customers and Sales view. When those columns change, I want to be able to see in once which Power BI raports are depending on them.

Do you have any ideas how to approach this? Any best practices to be able to have that kind of impact analysis?

Thanks in advance!

Ruben

[francorg]

At Ignite 2017 a “Data lineage tool” for Power BI has been announced for October 2017, among other new features.
https://powerbi.microsoft.com/en-us/blog/power-bi-at-ignite-2017-announcing-enterprise-ready-capabil...

All the other features has been released, data lineage is missing.
Does anyone has any update about it?

Thank you,
Roberto

[v-yuezhe-msft]

@Anonymous,

There is no such functionality in Power BI. Some ideas about data lineage have been submitted in the following links, please vote them up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18923233-data-source-and-report-lineage
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7025833-stronger-metadata-lineage-support
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13816188-build-in-power-bi-model-over-pbix-files-for-metada


Regards,
Lydia