Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.