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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
IADRIANS
New Member

pagination problem import

Hi, im trying to import register form an url with the API authorisation and I just can import the first 100 register. Im using a list of page and then a function that call this list in order to import all the register and everything was working well. The problem is that now, the url has change its pagination method and does not use the parameter "page" anymore. Now it uses the parameter "created_before". So i need to indicate the "id" of the last register in order to know from wich register i have to continue my import. Another problem is that the url does not return the register ordered, so a have to know the lower value of th id in each query to use it as a parameter for the following query.

 

Anybody who help me please?

 

Thanks in advance

1 ACCEPTED SOLUTION
IADRIANS
New Member

ThanK you for your posts, I finally find a solution using a function with Loop and calling the function again!!

View solution in original post

3 REPLIES 3
IADRIANS
New Member

ThanK you for your posts, I finally find a solution using a function with Loop and calling the function again!!

mahoneypat
Microsoft Employee
Microsoft Employee

Please see this video for a simpler way to apporach this.

Power BI - Tales From The Front - REST APIs - YouTube

 

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Thank you for your reply Pat,

 

The problem is that with the API of my url i don.t get the pagination information.  Im not high skilled with Query M and is dificult to me to understand how to use the value of a record in the next cycle.

 

As i posted before a need to import the records form my url. I have a limit of 100 records by query. So I had to use the lower value of the "Id" field to recuperate the next 100 records. I would like to limite the querys to 50 (for instances) in ordert to not importing a huges amount of records (just 100x50).

 

I will appreciate a lot your help. (If you have a code that i could use as an exemple it woul be very worht for me)

 

Thank you in advanced,

Ignacio

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors
Top Kudoed Authors