Microsoft Purview currently doesn't support query or stored procedure for lineage or scanning. Lineage is limited to table and view sources only."

Nikhil Singh 25 Reputation points
2025-04-23T12:53:56.93+00:00

Hi Team,

We would like to ask when it is planned to fix this limitation? How Microsoft is planning to fix this behavior and what is the estimated date of the fix being released for general availability?image (27)

Regards,

Nikhil

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
1,532 questions
0 comments No comments
{count} votes

Accepted answer
  1. Smaran Thoomu 22,505 Reputation points Microsoft External Staff
    2025-04-23T14:04:34.0066667+00:00

    Hi @Nikhil Singh
    Thank you for reaching out and for your interest in Microsoft Purview.

    You're right - as of now, Microsoft Purview does not support capturing lineage for queries or stored procedures, and lineage is currently limited to tables and views. This limitation is known and has been acknowledged by the product team.

    Regarding your questions:

    • Planned Fix or Enhancement: At the moment, Microsoft has not officially announced a timeline or roadmap update for lineage support of stored procedures or query-level operations.
    • Product Direction: Enhancing lineage capabilities, including extending support to stored procedures, dynamic queries, and other transformations, is part of long-term roadmap discussions. However, any new features or improvements are generally made available first in preview, followed by general availability (GA) depending on feedback and stability.
    • Stay Updated: I would recommend monitoring the Microsoft Purview Release Notes and Azure Updates page for the latest information on upcoming capabilities.

    Please let us know if you would like to explore any current workarounds or need guidance on integrating lineage for specific use cases.

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.