Report Stuck at Data Connection

[Anonymous]

Trying to connect to data source but always stuck at "Please wait while we establish a connection to filename.xlsx"

I've tested my other reports with same issue however issue does not happen when opening new pbi report. Any reason why this is happening and how do I fix it? Worse case scenario, how do I fix report without recreating the whole thing from scratch??

[mahoneypat · Accepted solution]

Trying making a new query to that source, and then open the advanced editor, copy the Source line and any other ones and replace the equivalent lines in your existing query.  Duplicate your query first in case you need to get back to where you are now (right click on the query and choose Duplicate).  If you can fix the existing query, then all your downstream stuff will not be impacted.

Regards,

Pat

[Anonymous]

Hi @mahoneypat I will use your suggestion as a last resort should the issue persist. Appreciate your help, thank you:)