I’m having a trouble connecting rest API for one of the tables that collects sales data for my business.
Since I cannot share streaming graphs of this data in airtable with my partners, I would like to bring in airtable data to power BI so that I and my partners can look up the situation at any time.
I have connected google, facebook, google sheets etc. to this service however, airtable is the only one that I’m having a big issue.

Given the API URL : https://api.airtable.com/v0/[base ID]/[table ID]?Api_key=[your api key],
I have tried so many method to connect in power BI, It doesn’t work.

• not to mention there is paid service out there that specialize connecting airtable and power BI only.

Please help me how I should resolve this issue.
Thanks in advanced.