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.

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    Hi PBI_ponderer 

    No I haven't met that issue. But before pointing finger on PBI you need to make sure what that column contains that causes the issue then act upon it. so by elemination look inside that column what is not correct, empty some rows from that column and verify... step by step you can find the issue.

     

    Let me know

     

  • 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