Forum Discussion
Solved
Importing multiple Tables from Excel file
Hi! I have a large Excel workbook with many worksheets and Tables. This is the "source of truth" for a report I'm building in Power BI. However, when I attempt to use the data in this Excel f...
In your screenshot, right-click the top folder (workbook name) and select Transform Data. From there, you can click on the desired tables to import.
Click the "Table" link in the Data column for each table you want to import. After you click "Table", you'll be able to perform transformations on the data.
Thanks again!