PowerBi Connecting to Data Source Error: (CreateFile: The system cannot find the file specified)

[baher1]

I am getting the following error when I tried connecting a data source to my PowerBi file. When connecting to the data source, there was a message saying "Please wait while we establish a connection".After 20 minutes, it ends up freezing for about 5 minutes, but then finally, I am able to select the tab I want in the Excel file to start building queries. Then a debug.log file appears beside the excel file with the following errors: CreateFile: The system cannot find the file specified. (0x2). My colleague Garlon may chime in on this thread as well. 

[v-eqin-msft]

Hi @baher1 ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @baher1 ,

Please go to File->Options and Settings->Data Source Settings, then select Change Source(highlighted in red line), please check the path and open file as right format.

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