Hello All, I was facing the issue of scemantic model failure due to the below error. It was running fine before from past fewdays I have Identified that the scemantic model refresh got turned off by throughing the error.
Data source error:
One or more errors occurred.;One or more errors occurred. An error happened while reading data from the provider: 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond'. The exception was raised by the IDbCommand interface. Table: public dim_date.
As per my analysis there is an issue with source connectivity else timeout has happen while executing query at power BI level.
For now I have rescheduled the refresh, It's working fine.
can someone please explain what's the root cause of this issue. Thank you.
#Dashboards #Reports
v-xiaoyan-msft
on:
Composite model. Measures do not IGNORE format str...
Hi @wtt,
The error message indicates that the connection attempt failed because the connected party did not respond in time. This could be due to network issues, firewall settings, or the data source server being down or unresponsive. Checking the network connectivity and ensuring that the data source server is up and running can help resolve this issue. It also suggests that the connection might have timed out while executing the query. This can happen if the query takes too long to execute or if there are performance issues with the data source. Optimizing the query or increasing the timeout settings in Power BI might help mitigate this problem.
If the issue is intermittent, it could be due to transient network issues or temporary unavailability of the data source. Monitoring the network and data source performance over time can help identify patterns and potential causes.
Hope it helps！
Best Regards,
Community Support Team _ Caitlyn