Terminé

Power BI: Power Query API Pagination with Cursor

Job Description:

I have a url with the structure:

https://baseurl&pagination=1

When you enter the url in the Web connector in Power Query you will get the result in the attachement:

The url will give us the 1000 first records and the cursor for the next page. I need to loop through all the pages to get all the records. I guess we need to use the function [login to view URL] somehow. So the next page will then be:

https://baseurl&pagination=2&cursor=”CursorForNextPage”

“CursorForNextPage” is the value for meta.next_cursor which you see in the attachment. We need to loop through until “meta.next_cursor” is null/blank

Compétences : Power BI, Microsoft PowerBI

Concernant le client :
( 13 commentaires ) Lier, Denmark

Nº du projet : #35366622

Décerné à:

surya2chandra

I can create a custom function to loop through multiple pages. I am ready to do it right now. Please message me in chat box. Thanks.

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(1 Évaluation)
1.2

12 freelances font une offre moyenne de 238 $ pour ce travail

BADRI1998

Hello Sir, I hold a preferred freelancer badge.! I can deliver within 8 hours I am doing Master's in RMIT University in this domain.I have read your project description I’m confident that I can do this I have great exp Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(58 Commentaires)
5.7
merinsinha

Power BI expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating f Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(1 Évaluation)
1.7
neznamvladan499

✔✔✔✔ Nice to see your posting ✔✔✔✔ Hi, Jon H.. I read your job posting and feel I can help you successfully complete your project now. I am good at Microsoft PowerBI and Power BI and I have completed the same project r Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
davidstrager

⭐⭐⭐⭐⭐ PowerBI expert ⭐⭐⭐⭐⭐ Hi, Dear I would like to discuss more regarding project via chat. Please invite me to chat. Thanks for reading my proposal.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
umairkaramat24

Hi! How are you doing? I have read the project description and really interested in this job, I have 4 years’ experience doing similar jobs regarding to these skills Microsoft PowerBI and Power BI. Please start the cha Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(0 Commentaires)
0.0
himanshukansal19

Hi, I have more than 3 years in writing MySQL queries, creating scripts over Python, performing complex excel functions and schedulers. In Data Visualization I have created various dashboards, reports on Power BI and S Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
0.0
chetanchouhan

Hey, I have 8 yrs experience in Power Bi. I can help you with this. Check out my queries below. 1- What tool you are using to get data from url, is it in excel or Power BI desktop.? 2- Is there any limitations to Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0