Lengkap

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

Kemahiran: Power BI, Microsoft PowerBI

Tentang Klien:
( 13 ulasan ) Lier, Denmark

ID Projek: #35366622

Dianugerahkan kepada:

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.

$50 USD dalam sehari
(1 Ulasan)
1.2

12 pekerja bebas membida secara purata $238 untuk pekerjaan ini

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 Lagi

$500 USD dalam sehari
(58 Ulasan)
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 Lagi

$200 USD dalam 4 hari
(1 Ulasan)
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 Lagi

$250 USD dalam 3 hari
(0 Ulasan)
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.

$100 USD dalam 7 hari
(0 Ulasan)
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 Lagi

$250 USD dalam 8 hari
(0 Ulasan)
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 Lagi

$90 USD dalam 2 hari
(1 Ulasan)
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 Lagi

$250 USD dalam 7 hari
(0 Ulasan)
0.0