Power query editor - API

Pbienthu · ‎08-10-2022

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

Anonymous · ‎08-15-2022

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.