Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Good afternoon all,
So I need help configuring an API… It looks like the data I am trying to pull is an array, in an array. And I’m not sure how to make my data populate!
I'm trying to load the following data:
Using this function:
And this table:
But this method isn't working. In the last picture you can see what populates above the advanced editor. A whole lot of nothing!
Any help would be greatly appreciated!
Those are list elements, not arrays. Use the List.* functions.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 66 | |
| 47 | |
| 43 | |
| 26 | |
| 19 |
| User | Count |
|---|---|
| 198 | |
| 126 | |
| 102 | |
| 68 | |
| 51 |