An error occurred while processing the semantic model

Hi Anonymousap ,

Thanks for reaching out to Microsoft Fabric Community and thanks for sharing the additional details.

Since the issue is intermittent, it is likely related to how the Power BI mashup engine processes data. Even if the queries run fine in SQL, temporary tables are created in the background during refresh. If these temp tables encounter duplicate values in columns used as keys, or if there are concurrent operations, it can occasionally trigger the “An error occurred while processing the semantic model” message.

Here are some steps given which resolved a similar issue: Solved: Re: Refresh failure - Microsoft Fabric Community

As mentioned by tayloramy , sharing the script that creates any temp tables and the structure of the source tables would also help in understanding why duplicates may be generated.

The gateway timeout error seen for PBI_ProdMetalTable is generally unrelated to duplicates. It may happen if the gateway server experiences resource constraints, network latency, or long-running queries. Increasing the timeout settings for the data source can help address this issue as mentioned here: Solved: Re: Dataset refresh error - timeout - Microsoft Fabric Community

Also, as already mentioned by tayloramy checking the gateway server for available resources, running the network port test, and monitoring refresh performance during scheduled windows can help identify the cause. Capturing advanced gateway logs during a failing refresh is also recommended.

Thanks to ibarrau  and tayloramy  again for addressing this earlier and valuable guidance.

Please reach out for further assistance.

Thank you.