Forum Discussion
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 Dashb...
If it is showing the tables, then not all the tables are displayed. The file is in XLSB format.
edhans
Community Champion
Community ChampionConvert 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