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? I have tried 'import' mode vs 'DirectQuery' and it still doesn't work. I am using the latest version of PBI Desktop.

 

Thank you!

Need Help

9 Replies

    • 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

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello, I ran in a similar issue and problem comes from the fact that Power BI does not support long strings. When creating a view truncating long fields, all the rows are ingested.

    This has nothing to do with Google Big Query limitations, it's a Power BI limitation

    I think it's perfectly legitimate to point finger to PBI because even if data is in an unsupported format, or in my case, length , having silent errors is not acceptable.

     

    Thank you 

  • Bamak's avatar
    Bamak
    Helper V
    5 years ago

    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