We use Power BI internally for reporting and datavis (highly recommend, fantastic tool). It can connect to a bunch of things but struggles with OAuth and GraphQL so I’ve built a few proxies - just using Azure Functions and bouncing the requests through so Power BI can pretend it’s dealing with a REST data source.
Basically whitelist resources that you want and the function uses GraphQL introspection to get all fields, and then queries for those. Includes primary key for relations (good stuff 8base team on including those) so you can do table joins as required.
Also supports incremental exports instead of all data every time (if
since query parameter is set, it filters on GraphQL side).
I imagine a few other people will face a similar situation so I’ve chucked the code on Github:
Code provided is for Azure Functions, but should be able to adapt to other platforms pretty easily (AWS Lambda or GCF).
If you’re looking for a free option, I’ve also started using Pipedream recently and rate it