Power Bi Service - Slow load from BigQuery

Hi FelipeDBA ,

You can use Incremental refresh and real-time data for datasets. With the help of it, Datasets with potentially billions of rows can grow without the need to fully refresh the entire dataset with each refresh operation.

Besides, you can manage the storage mode. The storage mode lets you control whether Power BI Desktop caches table data in-memory for reports. With the help of it, tables that aren't cached don't consume memory for caching purposes. You can enable interactive analysis over large datasets that are too large or expensive to completely cache into memory. You can choose which tables are worth caching, and which aren't.

For more details, please refer to:

Incremental refresh and real-time data for datasets

Configure incremental refresh and real-time data

Manage storage mode in Power BI Desktop

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.