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
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 

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    Hi Anonymous 

    Can you please share the doc where you get the info?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types#text-type

      But looking twice that was not my exact issue, text type in PBI is ~500MB and my biggest string was 1.3MB so this is more likely a memory overflow issue. Anyway real issue is that if user does not pay enough attention they'll end up working with incomplete data without any notification

      Cheers