Forum Discussion

MatiasM's avatar
MatiasM
Frequent Visitor
5 years ago

Issue importing data into Power BI Desktop

Hi Everyone, I'm new in the community, thanks to everyone for the support. This is really helpful for people who wants to start working with Power BI as I do.   I have a quick question: I'm havin...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

MatiasM , 320K not a big number.

Just make sure Excel is closed when you are loading it Power BI. I just doubt, excel is locked for editing.

 

Also, make sure you are on the latest version of Power BI. Close all open power bi files and try again. In case it still does not load, let us know.

  • MatiasM's avatar
    MatiasM
    Frequent Visitor
    5 years ago

    Thank you for your answer.
    I have the latest version and Excel it's definitely closed when I'm loading.

     

    Cheers

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      5 years ago

      Hi MatiasM 

      In the Navigator dialogue, it only shows a preview of the data and will not show all rows if a table has a large number of rows. This is an expected result. You can select this table and click OK to go on. 

       

      If you cannot select this table and go on, you can create a new Excel file and enter some small data in it. Then load this new file into Power BI Desktop. After it is loaded successfully, go to Data source settings and change the data source to the large file.

      Kindly let me know if this helps.
      Community Support Team _ Jing
      If this post helps, please Accept it as the solution to help other members find it.