Forum Discussion

lizzy's avatar
lizzy
Helper I
5 years ago
Solved

Bigquery column displayed incorrectly

I have a Google BigQuery table consisting of Year, Month, and Count. It looks and acts normally in BigQuery.

When I import it to Power BI, the Month and Year columns look normal, but the count column looks like this

 

"{""v"":{""f"":[{""v"":""2015""},{""v"":""March""},{""v"":""0""}]}}"

 

It's obviously JSON-like, and contains information from all columns instead of just the Count column.

This started happening a few days ago, potentially when I upgraded to the February 2021 release. It has happened with several tables, but not all tables.

Is there anything in the Data Source Settings that could be causing this, or is this a bug?

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Im seeing this issue when the name of the column is the same as the name of the table

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Im seeing this issue when the name of the column is the same as the name of the table

    • lizzy's avatar
      lizzy
      Helper I
      5 years ago

      Thank you so much, this is exactly it!