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

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

 

ADTRE's avatar
ADTRE
Frequent Visitor
1 year ago

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

 

 

And Excel.Workbook gives an error as well:

 

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