Conecting PowerBI with BigQuery

Hello,

I'm trying to conect Power BI with BigQuery, but it takes too much time.

The table in BigQuery have more than 40.000.000 registers. And I need all data for my reports.

When I conect, it takes more than 2 hours. Then, I needed to change the type of a column, more than 2 hours again.

Is there an easiest way for what I'm doing? Or something I can do that do not take so long?

Thank you.

lucianadfs1987,

Use DirectQuery mode to connect to BigQuery in your scenario.

Regards,
Lydia