Forum Discussion
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...
Thank you for your answer.
I have the latest version and Excel it's definitely closed when I'm loading.
Cheers
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.