Issue importing excel file in Power BI desktop

[PushkarP]

Hello,

I'm new to Power BI. This may sound very basic. However this is an issue I'm facing. 

I am working on a new Power BI report and trying to get data from an excel spreadsheet. I could import the file, and it was accidentaly deleted in the Power BI desktop, so I tried to load the same file again, however it failed to load and I see 'Please wait while we establish a connection to <filename>'. The excel file resides on my local machine and it is not a protected file. Please see attached screen capture for the message.

To my surprise I now see the same message for any of the excel file.

Can anyone help me with this.

Thank you in advance.

Pushkar

[sreenub]

Go to following path  and clear Permistions and try to connect Excel again

TransformData -> Data Source Settings 

[PushkarP]

No permossions for ecxel in there.

[Sumanth_23]

hi @PushkarP  - I do not see the screenshot in the below post. Also have you tried importing using a new BLANK Power BI desktop file? 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

[PushkarP]

Hi @Sumanth_23 ,

Sorry I missed it. Yes import works in a Blank Power BI desktop file. However as I have done some data trasformation in the current file I am trying to import the excel file in the current file as it will save a lot of rework.

[Sumanth_23 · Accepted solution]

hi @PushkarP - One thing you can do is that you can copy the script for the steps from the old file and apply to the new file. 

Also can you check in Query Editor and delete any reference to the old excel if they exist. 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!