Bigquery column displayed incorrectly

[lizzy]

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?

[Anonymous · Accepted solution]

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

[lizzy]

Thank you so much, this is exactly it!

[v-shex-msft]

Hi @lizzy,

What version of power bi desktop are you worked on? Did this issue only appear after the desktop client update?  BTW, any change apply on your data source side?

How to Get Your Question Answered Quickly

Regards,
Xiaoxin Sheng