Data Studio
1.6K members online now
1.6K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

csv URL direct into datastudio

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

Hi Everyone,

I'm struggling having to use sheets as the intermediate steps through importing a live csv URL.  

Is there any way to skip this step and import the data straight into datastudio?

Have been having issues with the importdata function failing as well as delays.

Thanks in advance!

Jamie

csv URL direct into datastudio

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

+1 also desperate for this

csv URL direct into datastudio

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Would be very interesting for me, too. +1

Re: csv URL direct into datastudio

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Found it Smiley Happy Function Importdata in Google Spreadsheet.

 

2017-09-22 15_51_39-Store.png

csv URL direct into datastudio

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

You get "Error, Resource at URL contents exceeded maximum size" at 1.5MB. 

csv URL direct into datastudio

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Same problem. I thought I could pipe curl to gsutil to use my large CSV from Google Cloud Storage as a source. But the upper limit on files from Cloud Storage is 100MB: "The total size of one or more of your files files exceeds 100MB.".