The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to Solution.
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!
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!