Opsgenie integration with PowerBI using Rest API

Question

I am trying to integrate Opsgenie alerts api in PowerBi using Web contents. But I facing challenges to fetch list of alerts lets say for last one months. As it limits the record to 100 for API call. Can you please help us with DAX query in powerBI to meet the requirement of fetching data for last month. can you please help on how we can use pagination as an option.

Ajaykumar Panchal · Answer

let iterations = 10, // Number of iterations url = "https://api.opsgenie.com/v2/alerts?query=", FnGetOnePage = (url) as record => let Source = Json.Document(Web.Contents(url,[Headers=[Authorization="GenieKey XXXXXXXXXXXXXXXXXXXXXXXXX"])), data = try Source[data] otherwise null, next = try Source[paging][next] otherwise null, res = [Data=data, Next=next] in res, GeneratedList = List.Generate( ()=>[i=0, res = FnGetOnePage(url)], each [i]null, each [i=[i]+1, res = FnGetOnePage([res][Next])], each [res][Data]) in GeneratedList

Luis Miguel Zuñiga Cervantes_ykzaey · Answer

Hi @Ajaykumar Panchal

I have the same problem. I've tried with loops in Power Query but didn't work.

Did you find the solution ?

Robert_x4i2gm · Answer

Hi @Ajaykumar Panchal !

A URL for the next set of alerts will be returned in the headers and body of your API call. We have documentation on pagination here:

https://docs.opsgenie.com/docs/pagination