Forum Discussion

dbliss's avatar
dbliss
Regular Visitor
2 years ago
Solved

List of Query Dependencies

Within Excel's Power Query Editor, under the view tab is the Query Dependencies Viewer.   Is there a way to build a Power Query table which represents the dependencies between all queries in tabular form?

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hello dbliss 

     

    Currently, neither Power BI Desktop nor Excel have a built-in feature that could represent the Query Dependencies in a tabular form. I couldn't find a third-party tool that would do that either. You may need to manually create a table that lists the dependencies. However manually tracking dependencies can be error-prone and time-consuming, especially for complex models.


    If you are looking for an automated solution within Power BI Desktop, you might want to consider submitting a new idea at the Power BI Ideas forum.

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello dbliss 

     

    Currently, neither Power BI Desktop nor Excel have a built-in feature that could represent the Query Dependencies in a tabular form. I couldn't find a third-party tool that would do that either. You may need to manually create a table that lists the dependencies. However manually tracking dependencies can be error-prone and time-consuming, especially for complex models.


    If you are looking for an automated solution within Power BI Desktop, you might want to consider submitting a new idea at the Power BI Ideas forum.

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!