Missing Fields in PowerBI from Airtable API extrac...

[HirenViraiyda]

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.

[ScottWorld]

@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]

@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.