Stripe Query

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

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-attribution?tab=overview

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