The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!