Forum Discussion
Anyone else getting an error when loading GCP Big Query table that has PK/FK constraints?
For some strangest reason - this column is read as struct with all the columns and PBI import fails.
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.
5 Replies
Hi, Vaivaivai
This user also complained something similar, GCP BQ Big Query Table import error if table has P... - Microsoft Fabric Community
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 ,
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.
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.
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.
