Forum Discussion

lovincasper's avatar
lovincasper
New Member
9 years ago

Whole Excel Workbook not uploading

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.

 

 

2 Replies

  • alanhodgson's avatar
    alanhodgson
    Solution Supplier
    9 years ago

    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

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    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?:smileyhappy:

     

    Regards