Importing Excel: missing worksheets

[jimbofandango]

Hi,

I have an Excel workbook with about 10 worksheets in it, residing on a SharePoint site.  Each sheet is more or less the same, with a named Table containing KPI data from a business function.  Each sheet is Protected with a password to lock some cells down for editing.

When I import it into Power BI web app (Get Data > Files > SharePoint-Team Sites), only 4 of the 10 worksheets are imported and show up in the Fields panel.

Further more, at least one of the sheets that is imported no longer exists in the actual Excel workbook!  I deleted it some time ago - how can it still be appearing in my Power BI?

I have tried making copies and importing from different locations, deleting all Datasets, Reports etc and starting again, but it still happens.

Completely baffled and tearing my hair out!  I must be doing something obviously wrong, but no idea what.  Any help much appreciated.

James, Power BI novice

[v-lili6-msft]

hi, @jimbofandango 

If you use the latest version power bi desktop: Version: 2.70.5494.761

https://www.microsoft.com/en-us/download/details.aspx?id=45331

And if you could try to download the excel file to local and try it again.

Best Regards,

Lin