Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ?
@amitchandak does the extension of excel i.e. xlsb have the impact in recognizing the tables?
@saisuraj , If the table has been marked as a table in excel, you should see it below , refer screenshot
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
@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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |