PBI not importing all records from BigQuery

[comandor]

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

Just refresh

We have 88064 rows

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?

[comandor]

Hi @v-eqin-msft 

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.

[v-eqin-msft]

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.