Navigation Table with nested dynamic api calls

[abanwar]

Dear Users,

I am facing some issues with Navigation Table. My requirement is to make nested api call to retrieve some details and display them as part of navigation table. 

e.g. in below code, instead of using navTable as output, If I use queueData as output. I see a correct result which contains informartion pulled from nested api call. However, when I try to display navTable as output, I only see the details I received from first API call but not the nested once.

any suggestion to understand why this issue is happening will be really helpful.

[v-eqin-msft]

Hi @abanwar ,

Not sure. But your second call need be dependent of the first call.

Refer to

Power BI/Power Query Data Privacy Settings And Errors Caused By Nested Values

https://medium.com/@miguel.brito/fill-table-with-data-from-nested-api-in-powerbi-5e5c59cf90f8

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[abanwar]

Hi @v-eqin-msft ,

Thank you for your response. 

Actually when I display the table with nested data as an output, it shows correct values. It's able to make nested API calls to retrieve necessary information. Only when I am trying to display it as part of navigation table, it doesn't work. I am not sure what exactly the problem is!