I imported a .csv as a connected table and it seemed to work fine, but when I tried to refresh it I got the following error message:
"The query results can not be retrieved. The result set exceeds the Quickbase API maximum result limit of 50,000 records."
So I opened the source .csv to have a look but found that there are only 11,000 records in it, so I'm not exactly sure why I'm being told that the number of results exceeds the limit.
I have some other .csvs that contain more data (~30,000 records) and those work fine. The only difference I can see with this dataset is that there are a large number of unsupported character entries that look like this:
The above string is present in the source .csv and being imported into QB via the connected table. The characters are 2 bytes each, so could this be causing QB to think there are more records in the .csv than there actually is?