Forum Discussion
Solved
BigQuery malformed data in PBI
So I am trying to bring in some data from GCP's BigQuery into PBI desktop and I can connect and pull the data just fine, however when I try to graph it, keeps givng me errors. In the GCP portal it l...
So it seems that BigQuery has something like "objects" which display as individual columns in their UI but when looking at the data in PBI it does not.
Fix was to create a new view and specifically accessing the columns via the object.column notation
Hi sdc ,
Based on my understanding,the folding error has to do with query run-time data type mapping and the subsequently associated flags.
You could refer to this sample:
https://github.com/Microsoft/DataConnectors/blob/master/samples/ODBC/SqlODBC/SqlODBC.pq
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.