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.
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?
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-Powe...) and it then magically worked using anonymous authentication.
Weird that it works differently on desktop vs on powerbi.com