Data Studio
1.8K members online now
1.8K members online now
Ask questions about Data Studio
Guide Me

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?