Get BigQuery Data

[nouraali369]

Hello,

I am trying to get data from a BigQuery view in a specific dataset, using service account authentication.

I am able to preview the view in BigQuery console, which means the underneath view query is working fine.
However, when i try to get this view into power bi using import mode, it gives below error:

View_LogicalCS_CH_Relationship (3)
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [42000] [Microsoft][BigQuery] (70) Invalid query: Array index 2 is out of bounds (overflow). '

I have also tried the direct query mode, and when i try to build any visual it gives same error

is there anything i need to configure ?

Would appreciate your support.

Thanks

[Anonymous]

Hi @nouraali369 ,

Please make sure the query you’re using in BigQuery doesn’t reference an array index that doesn’t exist.
When importing data into Power BI, the data types in your BigQuery view match the data types in Power BI. If there’s a mismatch, it could cause issues.
It could be caused by null or missing values in your data. check if your data in BigQuery doesn’t contain null or missing values in the arrays.
If you’re using an older version of Power BI, updating to the latest version might help resolve the issue.

Best regards.
Community Support Team_Caitlyn

[nouraali369]

Thanks, changed the view and not getting any error any more.