Forum Discussion
Anyone else getting an error when loading GCP Big Query table that has PK/FK constraints?
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.
- Simplify the data at the source by flattening it before importing it into Power BI. This ensures Power BI handles only flat, standard columns.
- If you are already working in Power BI, use Power Query to expand or transform the complex column into separate fields.
- 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.
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.
- Simplify the data at the source by flattening it before importing it into Power BI. This ensures Power BI handles only flat, standard columns.
- If you are already working in Power BI, use Power Query to expand or transform the complex column into separate fields.
- 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.