Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

When expanded column is not returning expected value rather delimited values of the entire row.

The data source is BigQuery and the expected value on the Sessions table is an integer. Why is it that it is returning what appears to be a delimited values of the entire row?  Appreciate any help. ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    Currently simliar issue has been sumbited internal.

    As a temporary workaround, try to make the table name and the column name be different to avoid this issue.

     

    Best Regards,
    Community Support Team _ Yingjie Li

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Looks like that column contains JSON.  You could try making a custom column with = Json.Document([Sessions]) to confirm and/or drill into that array.

 

Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Pat, 

     

    Thank you for looking into my problem. 

     

    Added a custom column Json.Document([Sessions]) and records contain the following error message

     

    DataSource.Error: ODBC: ERROR [42000] [Microsoft][BigQuery] (70) Invalid query: Unrecognized name: source; Did you mean bounces? at [3:5]
    Details:
    DataSourceKind=GoogleBigQuery
    DataSourcePath=GoogleBigQuery
    OdbcErrors=[Table]

     

    The preview of the table from BigQuery looks like this.