Capture Circular Dependency error

[ferryv]

I am trying to capture the current query in the #sections table in Power Query. 

The current query generates a circular dependency, so I tried using try [Value] otherwise null and several other ways to check which record in the seciton table generated the error. It e.g. captures the HasError value correcty (HasError = True), while others are false.

However, when trying to retrieve the value for HasError, it does not retain the TRUE value, likely due to the underlying table not having errors. Similarly when trying to get the record fieldnames and expanding them, and so on. I also tried to retrieve the error message via a range of other means. 

Does anyone have any idea how to retrieve this in power query?

[ferryv · Accepted solution]

I found an alternative route to achieve what I tried to achieve, so getting the error is no longer needed. I generated a uniquer tableid and compared that with the nested table internal id.

[v-hashadapu]

Hi , thank you for reaching out to the Microsoft Fabric Community Forum.

May i know if 'I found an alternative route to achieve what I tried to achieve, so getting the error is no longer needed.' mean your issue is solved. If it is, please share the insights here, which will help others with similar queries.

Also, please consider marking the answer 'Accept as Solution' so others with similar queries may find it more easily. 
Thank you.

[lbendlin]

I am trying to capture the current query in the #sections table in Power Query

for what purpose?  You already know which query you are in?