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