Hi @Poova ,
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.
Now accepting Kudos! If my post helped you, why not give it a thumbs-up?
Proud to be a Datanaut!