Whole Excel Workbook not uploading

[lovincasper]

Hi,

I have successfully loaded several Excel workbooks into Power BI with no issues.  However the latest Excel workbooks I have tried to load into Power Bi will only load 1 or 2 worksheets of that workbook.  The size of the Workbook is no more than 2 MB.  I have at least 2-5 worksheets in each workbook but maybe 1-2 of them will load.

[v-ljerr-msft]

Hi @lovincasper,

Did you receive any error when importing the latest Excel workbook? 

To narrow down the issue, could you try creating a new pbix file and only importing the latest problematic Excel workbook to see if all worksheets can be imported successfully?

Regards

[alanhodgson]

Hey @lovincasper,

This might be your problem since you said you have loaded several workbooks in PBI.

Link is here.

You can check your data use in PBI Service by going to the Gear icon in the top right.

Hope this helps,

Alan