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

That column may not contain valid JSON anymore (after Power BI tried to "help").  Are you able to send some example data?  I assume you are getting a JSON response.  If you paste your query URL in a browser you can copy/paste the JSON into a text file, store that in OneDrive or GoogleDrive and provide a link here.

 

Pat

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

It looks like the real issue is when the table and column have the same names. 

  • v-yingjl's avatar
    v-yingjl
    Community Support
    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