Connecting PowerBI with Shared Airtable

[ADTRE]

Hi. I have been provided a link to a live dataset by my client. They used airtable to generate this dataset - which is only approx. 2500 rows. The client then added this to a shared space and forwarded the link to me. This link is publically available (and I don't need to login to airtable to view it). How do I connect my PowerBI report to this link directly (i.e. without having to manually download this as CSV daily).

The link is in the format: https://airtable.com/appXXXXXXXXXXXXXX/shrXXXXXXXXXXXXXX/tblXXXXXXXXXXXXXX/

A few steps that I have tried:

1. Csv.Document connection connects me to the html code of the webpage. i.e.:

= Csv.Document(Web.BrowserContents(

= Csv.Document(Web.Contents(

2. Web.BrowserContents("URL")

This only imports 30 rows (out of the 2500 rows of data), and only 4 columns (I have about 30).

3. I have tried to use PowerAutomate to download the CSV from airtable - but it is unable to do so (it ends up downloading the HTML code instead of the CSV file). 

Unsure if there is a way to connect PowerBI with airtable directly without having to create a paid Airtable account.

[ZhangKun · Accepted solution]

"Public" usually means that you can browse and download it via the webpage, but if you want to access the RAW DATA, you need to go through a web API or parse the web page.

[lbendlin]

Csv.Document(Web.Contents()) is correct. If you click that link do you get the entire CSV?

[ADTRE]

Hi. Csv.Document(Web.Contents()) gives me the HTML code:

And Excel.Workbook gives an error as well:

[lbendlin]

That means that either you have the wrong link or they maybe don't even offer a download option.

[ADTRE]

I don't have the wrong link. The link I have been provided opens an airtable site when I use it on Chrome. The URL (provided by the client) has been shared publically - so I can open it if I use an incognito tab without any login credentials. I can export an Excel file from the URL, add this file to a SharePoint site and connect to it. But this process is manual since the airtable site updates daily. My main issue connecting PowerBI to an airtable site.

[lbendlin]

If the link is public share it here.