Forum Discussion
Import Excel With Multiple Tables - Only One Table Imported
Open the spreadsheet in Excel, go to Data -> Queries & Connections -> delete the connection listed there. Save.
Delete the dataset from Power BI service and try importing again. It should work now.
File is here, I think based on Microsoft's AdventureWorks database.
https://drive.google.com/file/d/1mBCR6M2MdZkYVew6Z4OG_iEIsTgK0C23/view?usp=sharing
Screenshot of results here: https://imgur.com/QNEXdqQ
- I downloaded the spreadsheet and all 4 tables loaded fine.
Screenshot:
https://drive.google.com/file/d/1EECHGdrZvRxIw7IHuH1FbODEhkPEjnTs/view?usp=drivesdkYes, this works fine in Power BI Desktop, but Power BI Service (at least the trial I'm using) does not find the other tables.
I published it to Power BI service and it still worked fine for me. I'm using PBI Desktop version 2.71 (July 2019); not sure if that makes a difference.
https://drive.google.com/file/d/1_1dPTjYEz12J08Udw68wpZ5rZHNlvgMq/view?usp=sharing