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?
@lucianadfs1987,Use DirectQuery mode to connect to BigQuery in your scenario.Regards,Lydia
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!