Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
comandor
Frequent Visitor

PBI not importing all records from BigQuery

I've got a huge problem trying to load my dataset from BQ (i use import mode)

Table you can see (no relation, just copy of table and subset of columns)

First load - 15360 rows

comandor_0-1635442640986.png

Just refresh

We have 88064 rows

comandor_1-1635442851283.png

 

Every refresh i get just random amount of rows. As a result data is totally incorect.

I expect to get about 600k records

Version: 2.98.882.0 64-bit

 

Any suggestions?

2 REPLIES 2
comandor
Frequent Visitor

Hi @Anonymous 

ODBC is not a solution, because I cannot use an auto refresh without a gateway

Other topic is without solution also.

 

If someone in PBI team knows about the problem?

 

Actually - when I upload to cloud, data loaded.

Anonymous
Not applicable

Hi @comandor ,

 

you may try to create a ODBC data source for BigQuery, then use ODBC connector in Power BI Desktop and write SQL statement in the connector to check if you can successfully import data

 

below are similar threads for your reference.
https://cloud.google.com/blog/big-data/2016/11/how-to-connect-bigquery-to-microsoft-excel-and-other-...

https://community.powerbi.com/t5/Desktop/BigQuery-Issue-not-importing-all-rows/td-p/1649540

 

 

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors