Forum Discussion
PBI_ponderer
5 years agoFrequent Visitor
BigQuery Issue - not importing all rows
Hello All, I am having an issue with BigQuery: in short, I have 573,347 rows in my table in BigQuery, yet PBI only imports 3,072 of them. Does anyone know why this is happening and how to fix it?...
Bamak
5 years agoHelper V
Hi
My compagny faces 2 problems when Power BI is connected to GCP Bigquery
- Some lines disappear when loading certain table models WITHOUT warning !!!
- A simple left merge on 2 BQ tables crashes on power query (bad folding send to BQ) , but OK for that we get a yellow warning
Sorry aj1973 , mr champion but since our tool is power ib, I consider it as the "data quality control tower"
Why not integration crashes , but please not without clear Warnings
Clear explanation of each issue (due to PBI limitations or GCP BQ limitations <-- BQ SQL bigdata compliant deals with 100s of millions of rows ;>) )
silent integration + missing lines = very very bad BI reliability
Power BI (on Desktop & Service) is THE integration control tower, so please show each issues messages
Work on data quality or stop native BQ connector on desktop because reliability is not good for customers