Forum Discussion
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 looks correct when looking at it:
However inside of PBI it does not:
Which I assume is the reason for the errors:
Error Message:
OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression..
Any ideas on how to clean the data or have it come in the right format?
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
2 Replies
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.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
