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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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