Avoid LIMIT 1000 check per update

Dear Friends,

I need to remove the LIMIT 1000 Power BI check when updating the report.

It happens that a couple of months ago I discovered that by using a view in BigQuery I could avoid the LIMIT 1000 check, this worked for more than 3 months without problems, but a week ago the same report that didn't do the LIMIT 1000 now does it.

This change was done with incremental refresh where I set 5 days of update, and as I said months ago I was running the query 5 times, one per day, per update, but now the check was added.

Query with limit 1000:

select `hostname`,
    `ep_page_location`,
    `Mercado`,
    cast(`event_date` as TIMESTAMP) as `C1`,
    `Navegador`,
    `categoria_dispositivo`,
    `subcategoria_performance`,
    `channel_group`,
    `campana`,
    `fuente_medio`,
    `mercado_campana_performance`,
    `plataforma_performance`,
    `nivel_1`,
    `nivel_2`,
    `nivel_3`,
    `nivel_4`,
    `medium_fixed`,
    `source_fixed`,
    `sesiones`,
    `usuarios`,
    `Page_view`,
    `sesiones_EsPagina_Salida`,
    `sesiones_EsPagina_Entrada`,
    `sesiones_NoPagina_Salida_Entrada`,
    `usuarios_EsPagina_Salida`,
    `usuarios_EsPagina_Entrada`,
    `usuarios_NoPagina_Salida_Entrada`,
    `Page_view_EsPagina_Salida`,
    `Page_view_EsPagina_Entrada`,
    `Page_view_NoPagina_Salida_Entrada`
from `sandbox-bigquery-345619`.`DWH_CORPORATIVO`.`v_reporte_trafico_general`
LIMIT 1000 OFFSET 0

Query with incremental refresh:

select `hostname`,
    `ep_page_location`,
    `Mercado`,
    `C1`,
    `Navegador`,
    `categoria_dispositivo`,
    `subcategoria_performance`,
    `channel_group`,
    `campana`,
    `fuente_medio`,
    `mercado_campana_performance`,
    `plataforma_performance`,
    `nivel_1`,
    `nivel_2`,
    `nivel_3`,
    `nivel_4`,
    `medium_fixed`,
    `source_fixed`,
    `sesiones`,
    `usuarios`,
    `Page_view`,
    `sesiones_EsPagina_Salida`,
    `sesiones_EsPagina_Entrada`,
    `sesiones_NoPagina_Salida_Entrada`,
    `usuarios_EsPagina_Salida`,
    `usuarios_EsPagina_Entrada`,
    `usuarios_NoPagina_Salida_Entrada`,
    `Page_view_EsPagina_Salida`,
    `Page_view_EsPagina_Entrada`,
    `Page_view_NoPagina_Salida_Entrada`
from 
(
    select `hostname`,
        `ep_page_location`,
        `Mercado`,
        `Navegador`,
        `categoria_dispositivo`,
        `subcategoria_performance`,
        `channel_group`,
        `campana`,
        `fuente_medio`,
        `mercado_campana_performance`,
        `plataforma_performance`,
        `nivel_1`,
        `nivel_2`,
        `nivel_3`,
        `nivel_4`,
        `medium_fixed`,
        `source_fixed`,
        `sesiones`,
        `usuarios`,
        `Page_view`,
        `sesiones_EsPagina_Salida`,
        `sesiones_EsPagina_Entrada`,
        `sesiones_NoPagina_Salida_Entrada`,
        `usuarios_EsPagina_Salida`,
        `usuarios_EsPagina_Entrada`,
        `usuarios_NoPagina_Salida_Entrada`,
        `Page_view_EsPagina_Salida`,
        `Page_view_EsPagina_Entrada`,
        `Page_view_NoPagina_Salida_Entrada`,
        cast(`event_date` as TIMESTAMP) as `C1`
    from `sandbox-bigquery-345619`.`DWH_CORPORATIVO`.`v_reporte_trafico_general`
) as `ITBL`
where `C1` >= TIMESTAMP('2025-01-05 00:00:00') and `C1` < TIMESTAMP('2025-01-06 00:00:00')

I did a lot of tests during these days to understand and I found out that a colleague of mine with exactly the same report, exactly the same permissions in BigQuery (from what the administrator told me) does not do the LIMIT 1000 check.

I have already read documentation and forums looking for an option about this, without success.

Please, any information or help would be useful.

I remain attentive to your expert comments.

Have a nice week.