I was loading 300 excel files from a folder, combining them in query editor and now as my pbi model is getting big around 200 mb, when I tried to re-load excel files in the data model, it spins forever with a message
“Please wait while we establish connection to excel” - I am literally scratching my head - same model, if created in new fresh PBI file, is working but I want data load in the original file as there are mother data models with which it has connections to represent visuals.
Could you try to copy the M code and create a new blank query and paste the code and reload. This will create the new connection while keeping your other file (for other visual) intact.
Hi @AbhinavKumar, did the response provided by @AnshP help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!
Hi AbhinavKumar, we’ve noticed that no response has been received from you since the 20th of January. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!