Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Airtable to PowerBI

Topic Labels: Importing & Exporting Sync
162 2
cancel
Showing results for 
Search instead for 
Did you mean: 
HirenViraiyda
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

@HirenViraiyda 

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

Milan_Automable
6 - Interface Innovator
6 - Interface Innovator

@HirenViraiyda

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.