Hello Community,
I want to sync all Airtable data into Power BI to create a dashboard. Is there any other way to fetch data from Airtable to Power BI besides this method?
https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-query
Thanks.
Yes, you can create a dashboard in Power BI by using Make’s Microsoft Power BI integrations, along with Make’s Airtable integrations.
If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.
- ScottWorld, Expert Airtable Consultant
What is your problem with the method from the article? I think that is the most straightforward way.
If you're open to using third-party tools, then, as @ScottWorld said Make is one option to sync data out of Airtable; also n8n, Zapier and Whalesync can do this.
It's probably the simplest way (apart from the article) to set up a periodic export to an Excel file, and then use the Excel file as a data source. This way you can also do some data transformations if you need to.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.