Forum Discussion
PBI_ponderer
5 years agoFrequent Visitor
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?...
aj1973
5 years agoCommunity Champion
Hi Anonymous
Can you please share the doc where you get the info?
Anonymous
5 years agoNot applicable
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