Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
@lucianadfs1987,
Use DirectQuery mode to connect to BigQuery in your scenario.
Regards,
Lydia
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.