BigQuery malformed data in PBI

[sdc]

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? 

[sdc · Accepted solution]

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

[V-lianl-msft]

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.