Airtble Vs Power BI

[Amar_Bl]

Hi folks,

Airtable and Power BI comparison. Could anyone tell (Explain) me the major prons & cons of Power BI and Airtable?

Thanks

[Hashim_Warren]

Power BI is a reporting tool that can pull in and organize data from several different sources. Airtable is a database too with a spreadsheet UI.

Hard to compare because the use cases are different

[Matthew_Billio1]

They could work together: http://mpolino.com/airtable-power-bi/

Microsoft PowerApps Connector Product Suggestions

Microsoft PowerApps, Power BI, and Flow would be incredibly well paired with Airtable. Our team uses Airtable these days for just about everything. We also happen to like Microsoft’s plans for the Common Data Model that PowerApps is using and really appreciate the insights that Power BI is giving us into our data. We think that we could build some incredible apps and dashboards if Airtable submitted their own connector to Microsoft here: https://flow.microsoft.com/en-us/blog/calling-all-saas-ap…

[Matthew_Billio1]

A bit late, but see my show and tell:

Airtable link to Excel via Power Query Show and tell

Here is a way to automatically pull information from airtable into Excel via power-Query using a bit of coding. If you are looking to just copy and paste the code you need without much explanation, ignore the details :slight_smile:

Details

SECTION 1- CONNECTING EXCEL TO POWERQUERY- The first issue a user may run into while trying to get data to automatically feed into Excel is creating an authenticated connection to Airtable from Excel’s powerQuery. The following code will be used in a later …