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.