Table/Column Level Lineage with Azure Synapse and Power BI

Question

Table/Column Level Lineage with Azure Synapse and Power BI

Sharma, Praghya (CONTRACTOR) 5

Hi Team,

IS there a way to track column/table level lineage in Synapse DB? And in Power BI.

I cannot see the details of column/table level lineage in both the sources i.e Synapse and Power BI. Please confirm

Any recommendation or alternative approach

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-05-30T21:25:57.5966667+00:00

@Sharma, Praghya (CONTRACTOR) Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-06-01T19:42:01.84+00:00

Hi @Sharma, Praghya (CONTRACTOR) ,

We received your feedback that the answer provided on the thread was not helpful.
Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback. In case if your feedback is regarding the missing feature kindly elaborate so that we can share the feedback to respective product owners.

If your survey feedback is not related to engagement, feel free to re-take the survey/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!

Thank you

1 answer

Your answer

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-05-30T21:25:57.5966667+00:00

@Sharma, Praghya (CONTRACTOR) Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-06-01T19:42:01.84+00:00

Hi @Sharma, Praghya (CONTRACTOR) ,

We received your feedback that the answer provided on the thread was not helpful.
Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback. In case if your feedback is regarding the missing feature kindly elaborate so that we can share the feedback to respective product owners.

If your survey feedback is not related to engagement, feel free to re-take the survey/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!

Thank you

Answer 1

@Sharma, Praghya (CONTRACTOR) Welcome to Microsoft Q&A forum and thanks for reaching out here.

Power BI - Microsoft Purview lineage:
Lineage of Power BI artifacts in Microsoft Purview is currently limited to below data source types:

Azure SQL Database
Azure Blob Storage
Azure Data Lake Store Gen1
Azure Data Lake Store Gen2

Column level lineage and transformations is supported only when using Azure SQL Database as source. Other sources are currently not supported.

Azure Synapse Analytics DB's - Microsoft Purview Lineage:

Synapse DB Lineage is supported if dataset is used as a source/sink in Data Factory or Synapse pipeline copy or data flow activities. In addition, this lineage support is limited to tables and views only.

User's image

For more info please refer to this documentation:

How to get lineage from Azure Synapse Analytics into Microsoft Purview

Here are existing feature request logged by other users, please feel free to up-vote and comment on them to help increase the priority.

Feature Request: Power BI Report Lineage

Lineage for Azure Synapse SQL Dedicated Pool from Power BI Dataset (Import or Direct Query mode)

You may explore custom lineage functionality as an alternative:

Custom Lineage and Column Mapping in Purview

Hope this info helps.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Sharma, Praghya (CONTRACTOR) 5 Reputation points

2023-06-13T07:45:42.7833333+00:00

@KranthiPakala-MSFT I want to confirm again if table level lineage/column level lineage is supported from Power BI to Synapse Analytics(synapse DB). Right now I can't see the lineage between them neither at table level nor at column level
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-06-13T18:29:52.9566667+00:00

Hello Sharma, Praghya (CONTRACTOR),

Unfortunately, Purview does not currently support the table/column level lineage of Power BI Reports.

Below is a feature request submitted for this functionality. This is open for the user community to upvote & comment on. Please upvote and leave a comment. This allows product teams to prioritize your idea against our existing feature backlog effectively and gives insight into the potential impact of implementing the suggested feature. Please let us know if you have any further questions.

Feature Request: Power BI Report Lineage

Share via

Table/Column Level Lineage with Azure Synapse and Power BI

1 answer

Your answer