Power query editor - API

Pbienthu — Wed, 10 Aug 2022 11:18:09 GMT

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

Re: Power query editor - API

Anonymous — Tue, 16 Aug 2022 05:17:59 GMT

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.

topic Re: Power query editor - API in Report Server

Power query editor - API

Re: Power query editor - API