I am struggling to connect Airtable to PowerBI and was wondering if anyone was able to accomplish this?
Here are my steps following the write-up from here: Sending Airtable Data to Microsoft Power BI & Power Query | Airtable Support
- Open Blank Report in PowerBI
- Select Get Data > Blank query
- From Home Tab click on Manage Parameters > New Parameter.
- Add the Name
- Type > Select Text
- Suggested Value > Any Value
- Current Value > Enter Token ID
- This is done for PERSONAL_ACCESS_TOKEN, BASE_ID and TABLE_ID
Please note, TABLE_ID was taken from the URL as marked in red below
Click On Query1 as shown above, click on Advanced Editor and delete a few default lines.
From the Sending Airtable Data to Microsoft Power BI & Power Query | Airtable Support, copy M Query, paste it into Query1, and select Done. At this point, I am prompted to Authenticate:
On Sending Airtable Data to Microsoft Power BI & Power Query | Airtable Support page, it is suggested to use Anonymous
When I click on Edit Credentials and select Anonymous, I get the following:
No Matter which item I choose from the dropdown menu and select connect, I get the same warning as above.
From the Data Source Settings, I made sure “Anonymous” is selected for all items under “Data source in current file”, and “Global Permissions”, but still no luck to use Anonymous
Instead of Anonymous; I could click on Windows or Basic and use my Airtable Credentials, and I can log in as it seems (I have also changed the same in Data Source Settings),
but now I have this error:
If I go further up, I see null, which makes me believe I am not getting any data.
Does anyone have working solution for this?
It looks like issue is related to Authentication... I am not sure how to resolve this and if anyone had similar case, please let me know. It looks like Windows or Basic is not an option as well as Web API or Organizational account
I was able to get my Airtable data into Power BI by following the integration guide. I think the most likely issue here is your personal access token's permissions. You'll need to make sure the token you're using has access to the base you want to query. It will need at least data.records:read, and you need to select the base under the Access section. For example:
That value (it should start with "pat") should be entered as the value of the PERSONAL_ACCESS_TOKEN parameter in Power BI.
Alternatively, you could call the API directly by passing the PAT as part of the API headers in a Web data source. In this case you would replace "YOUR_SECRET_API_TOKEN" below with your generated PAT.
