Tables from the same Excel worksheet is not being detected while loading the excel into the Power Bi

[saisuraj]

While loading the data from an Excel workbook that has multi tables in a worksheet..Power BI Desktop is not able to detect the tables from the worksheet. It is displaying worksheet rather than tables. can someone help to fix this ?

[saisuraj]

@amitchandak does the extension of excel i.e. xlsb have the impact in recognizing the tables?

[amitchandak]

@saisuraj , If the table has been marked as a table in excel, you should see it below , refer screenshot

[saisuraj]

Hello, @amitchandak Yes, I was expecting the same...but i am not able to find the Suggested Tables in the bottom pane...not in the top pane...Though my Power BI Desktop is May'22 version

[amitchandak]

@saisuraj , I am seeing this for quite some time, as this is my demo file. In excel it should be a table

Update to latest version and check, if there is an issue too, you can log an issue