Importing BigQuery Table through ODBC Connection

[forzajuve21]

Hello,

I am importing a simple view from BigQuery into Power BI Desktop using an ODBC Connection.

The view only consists of 5 records of distinct item counts grouped by item ID.

The view runs fine on BigQuery, displaying a 5 rows by 2 columns table with numerical values.

However, when I import to Power BI, the item ID column displays without a problem, but the item count column shows something like the following:

{"v":{"f":[{"v":"###"},{"v":"####"}]}}

The first string (###) is the item ID, and the second (####) is the distinct count.

Could you please let me know how I can get the item count column to show only the #### string?

Thank you!

[v-chuncz-msft · Accepted solution]

@forzajuve21,

You may add a custom column.

Json.Document([Column2])[v][f]{1}[v]