Loading Excel files

[Aud]

I'm trying to get data from Excel file and create report. I go trough Get data>Ecxcel Workbook  and  data where loaded to Power Query editor. I select Close & Apply and begins a never-ending Load proccess :  

What can cause this problem? File security, permissions ... 

[Aud · Accepted solution]

Hi, 

Thanks for help.

 IT colleagues checked my PC and found problems with Windows.

My PC reinstalled and the problem is gone 

Best regards

[v-yiruan-msft]

Hi Aud,

I'm sorry I wasn't able to reproduce your problem. What version of Power BI Desktop do you have? The Power BI Desktop version I used for testing is 2.99.303.0 64-bit (November 2021). The testing detail and the version of my Power BI Desktop are as follows:

If possible, could you please share the excel file you used with me? I will test later on my side to see if it can load successfully. Thank you.

Best Regards

[Aud]

I tried,  closed Power BI and  select Import data from Excel as data-source. I got the same result.

 

[Pragati11]

Hi @Aud ,

Did you start with a fresh new power BI file?

Also what is the size of data you are working with?

While bringing data from excel spreadsheet did you select the SHEET from which you want to bring data into Power BI or you only have one sheet on the spreadsheet?

Is your file stored locally or on any shared drive?

For how much time does this LOAD window displays?

Thanks,

Pragati

[Aud]

Hi,

Did you start with a fresh new power BI file? Yes I did

Also what is the size of data you are working with? 11 kb

While bringing data from excel spreadsheet did you select the SHEET from which you want to bring data into Power BI or you only have one sheet on the spreadsheet? Only one

Is your file stored locally or on any shared drive? Localy

For how much time does this LOAD window displays? After 10 min. I canceled

Thanks

[Pragati11]

Hi @Aud ,

Can you try closing Power BI and bringing the excel as data-source from front-end rather than Power BI Query Editor:

Thanks,

Pragati

[Aud]

Yes, I tried and the same result