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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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.

Top Kudoed Authors