AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

Split breaks integration between Google Sheets and Google Data Studio

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Most of my sheets have had seemless integration with Datastudio except one. Testing different parts of the sheets I have identified this as the culprit

=arrayformula(split(filter('Raw Data Aggregate'!A2:A,'Raw Data Aggregate'!A2:A<>""),"/",false))

 

It works perfect in sheets but breaks integration with Google Data Studio. 

Testing further I found out if I removed the Split, the connection with Googled Data Studio. This still works, 

 

=arrayformula(filter('Raw Data Aggregate'!A2:A,'Raw Data Aggregate'!A2:A<>""))

 

Does anybody have an explanation of why split breaks integration, and if there are other commands that will break integration?