Why Google data studio csv connector works wrongly

Question

I have a problem with this GDS connector, when I add my csv-file, configure connector and start working with data, data appears incorrectly. Here it works okay:

But when I add another column, it goes wrong:

You can see code in GitHub repository.

I’m new to GDS connectors, I don’t know how to solve this problem. I tried another connector by Supermetrics and it works fine, but they don’t share their code.

Answer 1

CSV

1) File Upload (Official CSV Connector by Google)

• How about using the CSV Connector by Google?
• Added a GIF showing the location from the Google Data Studio page:

2) Google Sheets (Alternative solution):

• There are two ways to import CSV data to Google Sheets:
  1. Import Data Set: Opening and saving the CSV file as a Google Sheet
  2. IMPORTDATA: The function imports CSV data from a URL
• Added an Editable Google Sheet along with a GIF to demonstrate the IMPORTDATA function:
• 

3) Fetch CSV Community Connector:

• The Fetch CSV Community Connector is not an Official Google connector, however it's an open source connector, so perhaps a user could have a look through provide some insights (it would be better to update the question with the relevant code). In addition, you could reach out to the authors of the connector by creating a New Issue.

Original Post: Date (Text) to Date (TODATE)

The date field is currently detected and formatted as a Text field. To ensure that the date field is a Google Data Studio recognised Date field, create the following Calculated Field that uses the TODATE function:

TODATE(date, "%Y-%m-%d", "%Y%m%d")

Google Data Studio Report as well as a GIF to elaborate: