Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Can Power BI do Streaming Pagerduty through API ?

Hello Team,
i have secured API Token for PD, can i do live stream of PD incident data in power bi, i am getting api output in json and it needs to update into power bi with csv/excel format. So that i can do modeling with design dashboard. Please let me know how it's possible.

 

Regards

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    You don't really want to use Power BI for the processing part, only for the display

     

    I have a similar setup that goes like this:

     

    - Create a Streaming Hybrid dataset ont he Power BI Service. Hybrid so you can keep some history

    - Power Automate (formerly Flow) to do the API calls on a schedule and to stuff the received JSON data into the Power BI Streaming Hybrid Dataset (there's a Flow action for that)

    - In the Power BI service create visuals that consume the dataset data. Pin these visuals to a Dashboard

     

    That way whenever a set of JSON data gets added to the dataset it will appear automatically in the dashboard tile.