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.
- Anonymous authentication
- Modes of authentications available
- I tried using my Airtable credentials as Username & Password and API key & Bearer token as well, but nothing is working.
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