GCP BQ Big Query Table import error if table has PK constraints

[dovile_kr]

Error: 

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)). '.

How data is read and how data is in BQ

All good if I remove the PK constraints

[v-mdharahman]

Hi @dovile_kr,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you are getting error related to type mismatch. As @rubayatyasmin already responded to your query, please go through the response and check if it solves your issue.

I would also take a moment to thank @rubayatyasmin, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[rubayatyasmin]

Hi, @dovile_kr 

change the data type and see what happens. refer:

powerbi - How to troubleshoot error while refreshing - Stack Overflow

Solved: OLE DB or ODBC error: Type mismatch. (Exception fr... - Microsoft Fabric Community