Forum Discussion

ADTRE's avatar
ADTRE
Frequent Visitor
1 year ago
Solved

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 forward...
Need Help
  • ZhangKun's avatar
    ZhangKun
    1 year ago

    "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's avatar
lbendlin
Super User
1 year ago

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

ADTRE's avatar
ADTRE
Frequent Visitor
1 year ago

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's avatar
    lbendlin
    Super User
    1 year ago

    If the link is public share it here.