Anyone else getting an error when loading GCP Big Query table that has PK/FK constraints?

[Vaivaivai]

For some strangest reason - this column is read as struct with all the columns and PBI import fails. 

[V-yubandi-msft]

Hi @Vaivaivai ,

Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.

[V-yubandi-msft]

Hi @Vaivaivai ,

We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

Your feedback is valuable to us, and we look forward to hearing from you soon.

[V-yubandi-msft]

Hi @Vaivaivai ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[V-yubandi-msft · Accepted solution]

Hi @Vaivaivai ,

This issue arises because Power BI does not fully support importing complex or nested columns, such as structs, from sources like BigQuery. When a column contains multiple fields, Power BI may not recognize it correctly, resulting in an import failure.

1. Simplify the data at the source by flattening it before importing it into Power BI. This ensures Power BI handles only flat, standard columns.
2. If you are already working in Power BI, use Power Query to expand or transform the complex column into separate fields.
3. Adjust the data privacy settings in Power BI. Setting the privacy level to "Ignore" can sometimes help manage nested values more effectively.

 If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[rubayatyasmin]

Hi, @Vaivaivai 

This user also complained something similar, GCP BQ Big Query Table import error if table has P... - Microsoft Fabric Community