Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Bug in Google BigQuery connector : column not parsed correctly

Submitted by Anonymous on ‎07-16-2021 08:04 AM

I observed an unexpected behaviour of the Google BigQuery connector :
When returning a table that contains a column with the same column name as the table itself, the column will contain the unparsed values of the entire row; instead of the actual column value.
Example attached, comparing the column "LOC" of the table also named "LOC" seen in BigQuery; versus seen in PowerQuery:

 BigQuery_bug_ColumnTableName.png

Status: New
See more ideas labeled with:
3 Comments (3 New)
Comments
v-yingjl
Community Support
Community Support
‎07-18-2021 06:52 PM

Hi @Anonymous ,

Could not reproduce it as far as my test. Potential reason for this issue could be that the column name and the table name are the same so power query load the whole table fields in the same column name.

Try to modify the table schema manually to change the column name in Google BigQuery, please refer:

Manually changing table schemas 

 

Best Regards,
Community Support Team _ Yingjie Li

Anonymous
Not applicable
‎07-18-2021 11:38 PM

Hi @v-yingjl ,
Thanks for the reply. I can confirm that the problem disappears once the column is renamed to be different from the table name. But it seems like a workaround... In my instance, I have access to BigQuery's schema; but hat may not be the case for other users

Bamak
Helper V
Helper V
‎07-23-2021 12:45 AM

Hi Guillaume

Very happy to see your message, because on my company we find ourselves a little alone facing the problems of the native big query connector

Microsoft and Simba (the subcontractor) do not seem in a hurry to correct them

For a year we have been facing 4/5 problems

 

- Desktop: Power query does not recognize columns whose name is similar to that of the SQL table

Gavity 2/5 - Power query issue     YOUR ISSUE 

 

- Desktop: issue (a crash popup)  after close and applying when you left merge table 2 on nullable mode  column

<--- root cause: sending SQL folding to BQ (SQL92 format) is not recognized by GCP

(limitation on BQ side)  : Severity 2/5

 

- Desktop and service: Some rows disappear on tables after models refreshes without warning pop-up or dataset refresh history log

  : Severity  5/5   -  issue Looks sounds  like  "bits"  limit 

 

- Desktop: Power query doesn' t unnest record type fields like the console does

Gravity 2/5 - Unnest via a BQ view

 

Dont t hesitate to contact me in order to create a group of demands ;>)   --> christophe.hervouet-ext@kering.com

 

 

Idea Statuses