Forum Discussion
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 us...
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