Forum Discussion

mrk777's avatar
mrk777
Frequent Visitor
3 years ago

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:

 

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

 

Appreciate your help, thank you!

Need Help

3 Replies

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    3 years ago

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

    #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.

    • mrk777's avatar
      mrk777
      Frequent Visitor
      3 years ago

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

      • edhans's avatar
        edhans
        Icon for Community Champion rankCommunity Champion
        3 years ago

        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