Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
chermus
Frequent Visitor

Report Refresh Error(s) - Cannot load model

Hello Community,

 

I'm about at my wit's end with PBI Desktop and the multiple error messages I receive when I'm refreshing my reports daily (scheduled refresh is not an option, presently). The most common error is the following:

chermus_0-1669836605142.pngchermus_1-1669836611701.png

 

My storage mode is Import for every single data source. These errors sometimes hang for so long that I need to force quit the program. Sometimes up to 5 times, just to get one report to refresh successfully. This issue has persisted for me through multiple versions/installations of PBI Desktop.

 

I've tried clearing permissions from all of my data sources, the issue persists. There must be another fix I can try. Can someone please help? 🙂

 

Thank you!
Chelsea

 

 

3 REPLIES 3
chermus
Frequent Visitor

Thank you Aniya,

 

My data source is a network folder. I will check with our IT department to see if they can provide these connection log records. However, nobody else in our organization is reporting errors like these at this time (we all use the same network drive).

 

As mentioned, scheduled refresh is not an option for me at this time. Due to organizational policy, I am unable to connect to my data source via the PBI service online.

Hi , @chermus 

If no one else in your organization has reported such an error, I think this problem may be related to the network folder data source of the desktop connection in your host, and it is a personal problem for you, if it is convenient, you can contact your company's IT department and work together to collect the connection log when the error is reported and see the difference between the log when the connection succeeds and the connection fails, so as to continue troubleshooting this problem.

Due to the restrictions of company security regulations, we cannot accept the logs you upload, which will contain your company's private data, so at this moment we can provide suggestions to this step, thank you for your understanding and time!

 

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

v-yueyunzh-msft
Community Support
Community Support

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.