fails with 'An error occurred while loading to the model.'

Thankyou, audreygerred for your response.

Hi rawisarak09,

We appreciate your inquiry submitted through the Microsoft Fabric Community Forum.

Based on my understanding, since the table loads correctly in a new PBIX file but fails in the existing one, the issue appears to lie with the model metadata within the current PBIX rather than with BigQuery itself. This might be due to cached relationships, hidden dependencies, or minor corruption in the file.

Please follow the steps below, which may help to resolve the issue:

1. Manually import the query. In the new PBIX where the table loads correctly, open Power Query Editor, go to Advanced Editor, and copy the complete M query. In the existing PBIX, go to Get Data, select Blank Query, open Advanced Editor, paste the copied query, and then click Load.
2. Clear local Power BI caches. Close Power BI Desktop and delete the following folders:
   %localappdata%\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces\
   %localappdata%\Microsoft\Power BI Desktop\Traces\
   Reopen the PBIX file and attempt the import again.
3. Test with a smaller copy of the model. Save a copy of the PBIX and remove most tables. Try adding the BigQuery table. If it succeeds, re-add tables gradually to identify whether a specific table or measure is causing the conflict.

We hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.