Forum Discussion

Aud's avatar
Aud
Frequent Visitor
4 years ago
Solved

Loading Excel files

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 ... 

Need Help
  • Aud's avatar
    Aud
    4 years ago

    Hi, 

    Thanks for help.

     IT colleagues checked my PC and found problems with Windows.

    My PC reinstalled and the problem is gone 

    Best regards

     

7 Replies

  • Aud's avatar
    Aud
    Frequent Visitor
    4 years ago

    Hi, 

    Thanks for help.

     IT colleagues checked my PC and found problems with Windows.

    My PC reinstalled and the problem is gone 

    Best regards

     

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    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's avatar
      Aud
      Frequent Visitor
      4 years ago

      Yes, I tried and the same result

  • Aud's avatar
    Aud
    Frequent Visitor
    4 years ago

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

     

     

    • Pragati11's avatar
      Pragati11
      Super User
      4 years ago

      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's avatar
        Aud
        Frequent Visitor
        4 years ago

        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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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