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.