Forum Discussion
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.
Hi tayloramy Thank you for the solution
i have 8 schedule refresh in a day for this dashboard, out of 8 only 2 or 3 times it fails because this (An error occurred while processing the semantic model) but with same table or diffrent table, other wise it refreshes perfectly, so why this heppens some time and not every times an my SQL queries are working fine in SQL, so can guide me to find root cause for this?
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.