Need to bring REST API data(stripe) into Power BI

[shantanu97]

I wanted to connect to a STRIPE(Payment Gateway) REST API to pull data from that system and use it in a Power BI Desktop report: https://stripe.topowerbi.com/

https://stripe.com/docs/api

If that's possible, could someone give me how to accomplish that?

[Aryna]

Hi there, yes, it is possible. You can use third-party connector for Stripe and Power BI integration. There are multiple of them, but I used this one: https://vidi-corp.com/stripe-power-bi-connector/

Hope it will be useful!

[PhilipTreacy]

Hi @shantanu97 

This post shows how to connect to Stripe API and retrieve data from it

https://www.myonlinetraininghub.com/getting-started-with-apis-in-power-query

Regards

Phil

[Pascal_KTeam]

I'm also using Stripe and have loaded all data to Power BI. It's a tricky task and there are many things to consider so I can't just give the answer how to do it in here. But please feel free to reach out to me via www.kteam.ch and I'll show you how it's done. 

[amitchandak]

@shantanu97 , refer if this one works for you

Rest API
https://community.powerbi.com/t5/Power-Query/Using-a-REST-API-as-a-data-source/td-p/50400
https://www.progress.com/tutorials/odbc/directquery-your-custom-rest-api-in-power-bi
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/

[shantanu97]

@amitchandak I am new to Rest API. Can you give me more information in respect to stripe data. It is better if you can show some something with respect to stripe data.

If you give some example how to bring stripe data into Power BI.