Hello, I created a few simple databases in Airtable and wanted to test the access to them with Power BI.

I tried this simple query with Postman:


https://api.airtable.com/v0/<BASE-ID>/<TABLE-id>?api_key=XXXX


and it works great and instantaneously.

But the same URL in PowerQuery like this:


Json.Document(Web.Contents("https://api.airtable.com/v0/<BASE-ID>/<TABLE-id>?api_key=XXXX"))


is not doing anything. Just trying to establish a connection or I don’t know. It doesn’t give any error message.

I also have tried this guide:

and it is also not working and not giving any error message.