Forum Discussion
Connecting PowerBI with Shared Airtable
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.
"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.
6 Replies
"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.
Csv.Document(Web.Contents()) is correct. If you click that link do you get the entire CSV?
