Power query editor - API

[Pbienthu]

I am trying to get the details for azure cost management. When I hit the endpoint

"https ://consumption.azure.com/v3/enrolments/7792450/usagedetails?startTime=2022-01-01&endTime=2022-08-01" 

it gives me "next link" as a column which I can use to get the next set of data

the next link looks like 

https://consumption.azure.com/v3/enrolments/7792450/usagedetails/next page?sessiontolen=24:60881859&skiptoken=327C3030307C313040307C7365735789&skiptokenver=v1&id= b2637c1-0ba3-4733-9a43-55ch54f2cc3a

How can use this next link inside my api call in query editor so that I can get complete set of data

[v-xiaoyan-msft]

Hi @Pbienthu ,

In the investigation process, I found a relatively detailed tutorial, the OP seems to have encountered similar problems with you, you can refer to his sample to see if the problem has helped you.

Power BI - Call Azure API with nextLink 

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.