Report Refresh Error(s) - Cannot load model

Hi , chermus 

According to your problem description, you are using the data connection mode of import, and when refreshing in desktop, you will encounter multiple refresh unsuccessful problems, you need to try multiple times to succeed, and the error seems to be related to the data source disconnection, unable to establish a connection with the data source, here are my suggestions and mitigations for your current error situation:

(1)To find the root cause of the problem, you need to contact the administrator of your data source, collect the connection log records between the data source and the desktop, and see why the connection did not succeed, but it can be successful in several attempts, whether it is because the data source frequently drops or the desktop problem.

(2)You can try to publish the report to the service, configure the data source credential connection, and start a scheduled refresh for the data source, because the refresh on the Power BI service will do several retries after the connection cannot be successful, and then the error will be reported after failure, and it can be set once every half an hour, up to 48 times a day in the premium capacity, you do not need to manually try in the desktop, you can refer to this official document for details:

Configure scheduled refresh - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly