Configuring auto refresh in Power BI for fetching latest Airtable data

I have integrated Airtable tables into Power Bi desktop using API key. Now I want to set up the auto refresh of data on Power Bi online and it asks for credentials. I am not sure what credentials I should be using as I tried API key & Bearer token, but nothing seems to work.

Authorization worked well on Power Bi desktop (check my post here: Airtable to PowerBI easy integration with API key).

If anyone has any ideas, please help me to set up auto refresh.

  1. Anonymous authentication

  1. Modes of authentications available

  1. I tried using my Airtable credentials as Username & Password and API key & Bearer token as well, but nothing is working.

1 Like

Has anyone found a solution for this issue? We are also running into an issue with auto-refreshing data from Airtable in Power BI.

@Akshay_R did the solution posted on reddit https://www.reddit.com/r/PowerBI/comments/a4aure/configuring_auto_refresh_in_power_bi_for_fetching/ work for you?

Still doesn’t work. It’s almost certainly a Power BI problem. So if anyone has any luck getting any answers from them let us know!

I had this same issue, reconfigured it as per this article (https://support.airtable.com/hc/en-us/articles/4403440453015-Sending-Airtable-data-to-Microsoft-Power-BI-Power-Query) and it then magically worked using anonymous authentication.

Weird that it works differently on desktop vs on powerbi.com