Custom Data Connector Oauth2

Hi VinceG0214 

You M queries are too complex and seems not valid.

To create an M query in the Query Editor, you follow this basic process:

Create a series of query formula steps that start with the let statement.,

Output a query formula step using the in statement. Generally, the last query step is used as the in final data set result.

https://docs.microsoft.com/en-us/powerquery-m/quick-tour-of-the-power-query-m-formula-language

Please take a look at the following examples about how to connect to API in Power BI Desktop.
Get Data from Twitter API with Power Query
Power BI – Connect to your secure API

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.