Forum Discussion
excel data source won't refresh, just hangs
Hi nesnej ,
According to your statement, I think your refresh got stuck on in Power BI Desktop.
You can try the following:
1. You can refresh by "Refresh Preview" to refresh each table and you can find which table will return error.
2. Usually, it is caused by the vast amount of data. Please just import the tables that you need to calculate or you could turn off the option of "Include in report refresh" for the tables that you won't calculate.
3. Or it is recommended to cancel the following options in Power bi Desktop, and then refresh your data model
This is a link to related content, I hope it will help you:
https://community.powerbi.com/t5/Desktop/stucking-on-creating-connection-in-model/m-p/276796
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi nesnej ,
According to your statement, I think your refresh got stuck on in Power BI Desktop.
You can try the following:
1. You can refresh by "Refresh Preview" to refresh each table and you can find which table will return error.
2. Usually, it is caused by the vast amount of data. Please just import the tables that you need to calculate or you could turn off the option of "Include in report refresh" for the tables that you won't calculate.
3. Or it is recommended to cancel the following options in Power bi Desktop, and then refresh your data model
This is a link to related content, I hope it will help you:
https://community.powerbi.com/t5/Desktop/stucking-on-creating-connection-in-model/m-p/276796
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.