Reply
abanwar
Regular Visitor
Partially syndicated - Outbound

Navigation Table with nested dynamic api calls

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.

 

abanwar_0-1644519280144.png

abanwar_1-1644519538404.png

 

 

2 REPLIES 2
v-eqin-msft
Community Support
Community Support

Syndicated - Outbound

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.

Syndicated - Outbound

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!

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)