Forum Discussion

PBI_ponderer's avatar
PBI_ponderer
Frequent Visitor
5 years ago

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?...
Need Help
PBI_ponderer's avatar
PBI_ponderer
Frequent Visitor
5 years ago

Hi Amine,

 

Thanks for taking the time to reply. I found that it was actually a PBI issue: I was trying to import some text data and for some reason PBI didn't like it, when I removed that column containing text from the import - everything worked and it imported all of the rows. Have you ever had this experience before? It is strange because up until last week PBI was importing all of the rows with the text data but then just stopped.

Allegro's avatar
Allegro
Helper I
4 years ago

Hello PBI_ponderer

 

i having the same issue, by any chance that column text data was a json code? or a massive amount of text?

 

  • Bamak's avatar
    Bamak
    Helper V
    4 years ago

    Hi Allegro

     

    It's  a buffer issue on the Bq connector knowed by Ms and Simba (the sub contractors) 

     

    Don't hesitate to complain fort that on pbi issues forum