Forum Discussion

sdc's avatar
sdc
Helper I
5 years ago
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...
Need Help
  • sdc's avatar
    sdc
    5 years ago

    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

sdc's avatar
sdc
Helper I
5 years ago

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