Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
FlorianF
Frequent Visitor

Function for dynamic pages don't work correctly

Hi guys,
 
I am struggling with a function that should read all the pages of my API call, where I don't know the amount of the pages.
 
But when I try it, my query gets a list of hundreds of lists (pages), but most of the are empty. In this special case there are only 2 pages
 
Where is my issue, that he read pages, that actually not exists and have no content?
 
Here are some screenshots of my setup.
 

368841843_2478334632340646_4917302238146501478_n.jpg

369069826_2478334699007306_1497193025998393791_n.jpg

369043871_2478334769007299_3405476188078217366_n.jpg
 
369026703_2478334852340624_8971302712993990640_n.jpg
Can anybody help? 🙂

 

Thx Flo
3 REPLIES 3
FlorianF
Frequent Visitor

Hi Ibendlin,

 

I crated a text environment with some data. Maybe you can test it with that.

 

API URL: https://ffdevelop.weclapp.com/webapp/api/v1/...

 

Authentication is basic:

Username: *

Passwort (Token): 082d72cd-b804-45b3-a100-a8f74d267879

 

Maybe you find a solution. 🙂

 

Thanks!!

 

there is something wonky going on with the properties query parameter.  Still need to figure that out.  The rest works fine.

 

see attached.

lbendlin
Super User
Super User

Your code looks ok, but please understand that it is impossible for us to troubleshoot your API connection without having access.  Maybe you are receiving empty strings back instead of nulls ?

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.