0

I have referred to solution provided here:

How to get paginated data from API in Power BI

But problem is same data that is in page 1 is getting repeated for every page Example: Page 1 we 106 rows page 2 same 106 rows page 3 same 106 getting repeated instead starting from row 107 on page 2.

Would appreciate if anyone can help me to resolve this.

Improve this question
4
  • Can you show us your M query? Commented Dec 2, 2021 at 12:11
  • Here is the M Query of function and total pages Commented Dec 3, 2021 at 16:22
  • Get Page M Query (truncated query) ----------------- (page as text) => let Source = Json.Document(Web.Contents("abcenterprises.thefutureis.mobi/1/devices/business_devices", [Headers=[#"API-Token"="xxxxxxxxxxxx"]])), #"Converted to Table" = Table.FromRecords({Source}), #"Expanded response" = Table.ExpandListColumn(#"Converted to Table", "response"), #"Expanded response1" = Table.ExpandRecordColumn(#"Expanded response", "response", {"id", "ref_device_id", "business_id", "esn", "meid", "imei", "msn", "status", "created_at", "updated_at"}) Commented Dec 3, 2021 at 16:32
  • Total_Pages let Source = Json.Document(Web.Contents("abcenterprises.thefutureis.mobi/1/devices/business_devices", [Headers=[#"API-Token"="xxxxxxxxxxxxxx"]])), pagination = Source[pagination], List = {1..pagination[pages]}, #"Converted to Table" = Table.FromList(List, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type text}}), #"Invoked Custom Function" = Table.AddColumn(#"Changed Type", "Data", each getpage_devices([Column1])), #"Expanded Data"=Table.ExpandTableColumn Commented Dec 3, 2021 at 16:35
Related questions
5
Power BI Datasets from REST API and PowerBI Designer
12
How to get paginated data from API in Power BI
0
How can I setup Pagination in Excel Power Query?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.