- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Excel DataSource doesn't load completely
Hi,
Power BI beginner here.
I am creating a dashboard with multiple excel sources . The excel file currently has 300k+ rows !! (I recommended not to use excel for storing data but the end user needs to validate data in excel and to store in a different location)
I tried loading this file into Power Query and only 173k+ rows are loading. I don't see any errors in the transformation steps either. Any reason why this could be happening?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I checked on the file and no blank rows in between and no defined table / range as well. It is actually an output file from Alteryx where new rows of data are appended to the existing sheet. Also I tried automated workflow to save it as csv file and there were no issues. Solved my problem for now, but i am still curious to understand as to why there is problem in loading the file in .xlsx format
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
I would check the following:
- Ensure there are no completely blank rows in the Excel dataset. A break in contiguous data will prevent Power Query from seeing it as a single set of data.
- If your data is formatted as a 'proper' table, ensure that the bounds of the table reach right to the end of your dataset.
- If it's not formatted as a 'proper' table, then format it as such. Then try importing to Power Query using the named table reference, rather than the sheet name.
Pete
Now accepting Kudos! If my post helped you, why not give it a thumbs-up?
Proud to be a Datanaut!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-12-2024 09:48 PM | |||
03-24-2022 12:17 PM | |||
01-29-2025 04:24 AM | |||
05-07-2024 07:35 PM | |||
Anonymous
| 03-02-2022 01:44 AM |
User | Count |
---|---|
32 | |
18 | |
14 | |
11 | |
8 |