I’m attempting to integrate Airtable and Power BI to create reports. Using the API authentication key, I am able to connect to one of my tables in Power BI. However, the JSON string only contains 100 rows when connected.
No. If you are using the API to gather records, you must use the pagination values to continue to make 100-record requests until all data is made available to the PowerBI connector.
I wish I could, but I currently have 7 projects on my plate and my rate is $250/hr, so unless you have an integration budget and can wait a few days, you probably need to find a consultant or a user with lots of extra time in the community.