Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
mrk777
Frequent Visitor

Power BI not recognizing the Excel Tables when Excel fiie is imported from SharePoint

Hi, I have been trying to import the Excel File, where I have more than 3 tables (side by side maintained in a single sheet which I would like to connect as separate Data Tables in power bi for Dashboard purposes. Unfortunately, the tables are not shown separately while importing and the sheet data looks so messy, it has combined and read all the table columns as one single dataset. Attached is the screenshot for your reference:

 

Tables are not showing while importing the file:

mrk777_1-1682505483210.png

 

Tables maintained in the Excel file which is placed in the Teams Channel folder (SharePoint):

mrk777_2-1682505651117.png

 

Appreciate your help, thank you!

3 REPLIES 3
edhans
Super User
Super User

Those are all tables. Sheet data has a different icon.

edhans_0-1682533453945.png

#2 above is how Sheet data looks. #1 is a true Excel table.

 

Is the file saved as XLSX or XLSM? I've seen issues when saving as XLSB. Also as XLS, but those don't store tables properly anyway.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
mrk777
Frequent Visitor

If it is showing the tables, then not all the tables are displayed. The file is in XLSB format.

Convert it to XLSX and try again. There are some bugs I've discovered with the XLSB format that are, to me, as problematic as the old XLS format.

Just try it. If it works, you can open a support ticket with MS on Excel + Power BI with XLSB. But I tell 100% of my clients 100% of the time, convert to XLSX (or XLSM if a macro needs to be retained) and abandon XLSB for Power BI interoperatibilty



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.