Forum Discussion

RDTBartlett's avatar
RDTBartlett
Data Storage
12-09-2021

Google Sheets Connector Elasticube Build Error - Failed to read row - need help!

When using a Google Sheets connector in an Elasticube model, we are receiving a build error that doesn't make sense due to the data in it.

Error:

Build failed: base table "google_sheet" was not completed as expected.
Failed to read row: 0, Connector (Cannot union files with different schemas. Please make sure the unioned files contain the same columns titles, data types, and tabs.).

Data:

A simple Google Sheet with 55 columns, 320 rows (inc header). There are no additional tabs. The sheet is fed data by another software.

The connector to Google sheets has previously been functioning for other Google Sheets with no issue.

Any help or thoughts would be much appreciated!

Data Connectors

2 Replies

Replies have been turned off for this discussion
  • OlehChudiiovych's avatar
    OlehChudiiovych
    Sisense Employee
    12-13-2021

    Hello! Thank you for sharing this great question! Upon initial review, there are a few follow up questions required to provide the best solution.

     

    To ensure an optimal experience for both community members and you, I would like to recommend submitting a formal support ticket to: Submit a Support Ticket

     

    Looking forward to connecting in more detail soon.

    • RDTBartlett's avatar
      RDTBartlett
      Data Storage
      12-18-2021

      Thanks - I did exactly that and got an answer.

      Support were very helpful in advising me that it was due to emojis (special characters) being placed in the column names.