Failed to extract data into Looker Studio.

[JackHarrison]

I am working on a dashboard that I have been given access to by a colleague. I also have access to the data sources. I am looking to update the data in the board having fixed an issue in the source data but whenever I attempt to Save and Extract the data I get an error stating: Failed to extract data into Looker Studio.

[Carlos_Leon]

Hi there,

Here is some troubleshooting;

• Go to the data source in Looker Studio and manually refresh the connection. This can help resolve any temporary issues.
• Clear your browser cache and cookies, then try saving and extracting the data again.
• Try disconnecting and reconnecting the data source in Looker Studio to reset the connection.
• Depending on your data source consider using an external connector like windsor.ai.

[DataFool]

I'm having the same problem and I find it very frustrating that the only message is that it failed, without giving any clue as to why it failed. There's not even an error ID! 

I followed each of your steps, except the last one. 

In addition I did these tests:

• Created a new data extract from a different Google sheet, which worked. I wondered if the total cell count (649000 vs 958000) was the reason why the test succeeded, but the documentation mentions the max data limit is 100 MB and mine is only 2 MB. 
• Created a python script using regex to look for suspected illegal characters in the sheet.
  [^a-zA-Z0-9\s\w\.,?!\'"-,- :\/><@\\|] 
  I also modified it to scan the original CSV file. None were found. 

[DataFool]

The new data extract that I created last time no longer works. I'm getting the "Failed to extract data" error message now. What's happening here? Why can't I find a resolution?

[DataFool]

I may have found how to bypass this error!!

I update my Google sheet every month or so with new data. I replace the sheet using File>Import and I have 3 columns that I calculate using some python in google colab where I import the sheet into a pandas dataframe, add a few columns and export the contents back out to the sheet. 
I noticed after I do this that the date format is  Date (YYYYMMDD). When I upload the CSV file directly to the google sheet, it comes up as just Date.   The (YYYYMMDD) is the older style of date format. 
I need to convert it to the newer date format by choosing Date in the dropdown field. 

After converting, I tried to use data extract and it failed again.
BUT, after I clicked "refresh fields" at the bottom, it worked!

I hope this is reproduceable!