KNOWLEDGE BASE

Error Code B1F2A0F3 Internal Error - "An unexpected error occurred and the operation could not be completed" When Adding Group Field in Google BigQuery to View


Published: 13 Sep 2022
Last Modified Date: 14 Sep 2022

Issue

The following error occurs when a group field is used with Live Google BigQuery connection.
Table A and Table B are joined with the relationship and the group field is created in Tableau B and adding in the view that only has the field in [Table A], the below error occurs.
User-added image

Internal Error - An unexpected error occurred and the operation could not be completed
Error Code B1F2A0F3 

 

Environment

  • Tableau Desktop 2022.2.0, 2022.2.1
  • Google BigQuery

Resolution

Please try the below possible workaround.

Option 1:
Instead of using a group field, make a calculation to manually set the group like below.
IF [Category]="Furniture" OR [Category]="Technology"
THEN "Group A"
ELSE "Group B"
END

Option 2:
Instead of using a LIVE connection to Google BigQuery, please try using an Extract connection.
Did this article resolve the issue?