Set up automatic data refresh on Power BI

[olivia_lay]

Since the AirTable API was limited to 100 entries in PowerBI, we have manually inserted a code found on that video: How To Fetch Unlimited Entries in Airtable To Power BI via API - YouTube

Now, data is falling into PowerBI? However, we connot set up automatic refresh of data.

Do you know how can this problem be fixed? Meaning autonmatic refresh of data after unlocking the 100 entries limit.

Thanks!

[Jimmy_Tan]

Using following Airtable's M query but reformat things using RelativePath should work according to this blog.