Data Studio
1.8K members online now
1.8K 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?