Stripe Query

[Thoneyman]

How do I connect to Stripe. The connector is no longer there. 

I have an API key, but need to know the query. Thanks!

[karaoan]

There is also a fully automated solution out there that automatically loads all Stripe data to an Azure SQL database and generates the relevant Power BI models and DAX metrics for subscriber and billing analytics: Stripe | Integration with Power BI & Excel | Acterys Next Level Planning

[adelheni]

Hi, 

If you have the API key, you don't need a query.
Just press on getting data, then web, and just put your API URL there and you'll get your data.
But of course, this has its limitation to how fresh the data is, and how many queries are aloud per day.
But to get around this you should use a third-party connector.
I believe this app has what you need 

https://appsource.microsoft.com/en-us/product/power-bi/windsorgroupgmbh1585043281642.windsorai-attri...

[v-juanli-msft]

Hi @Thoneyman 

Hope this will help you.

http://stripe.topowerbi.com/

You can get data off of Stripe's servers using the Stripe REST API, which exposes information about core resources, payment methods, subscriptions, and more. To get a list of all customers, for instance, you could call GET /v1/customers.

or use custom connector.

https://github.com/mbilling/PBIConnectors

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.