Looker Studio take too much time to load charts

I have a problem with looker studio as demonstrated in the video. The dashboard takes too long to load, in this case about 1 minute, but there are cases that take much longer. The problem is that this is sporadic, most of the time this dashboard loads in just over 5 seconds.
And while it tries to load it is possible to perform queries in the bigquery and in the table normally and the data is returned quickly.
Another point is that the query that runs in looker studio does not appear in the bigquery history (nor with the running status).

I already found people complaining about a similar problem when there are pivot tables, but I found this problem using several types of chart.
I've already checked the slots occupied by bigquery and the vast majority of the time, and at times when errors occur, we have more than half of the available slots capacity.
BI Engine is already enabled also for the tables where it is possible.

My main hypothesis is that the

 

looker studio is taking too long to send the request to the bigquery to perform the query.

Anyone can help me?

Cheers, nelson_pires

 

nelson_pires_0-1694017176521.pngnelson_pires_1-1694017178851.png

 

0 4 957
4 REPLIES 4

@Roderick FYI 

Hey there,

 

Thanks for flagging. Let me see if I can get some eyes on this. 

Hi, @Roderick! Do you have some news about this topic?