Forum Discussion

jcmayernik's avatar
jcmayernik
Regular Visitor
2 years ago
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...
Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    jcmayernik,

     

    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.

jcmayernik's avatar
jcmayernik
Regular Visitor
2 years ago

Thanks for your quick response! Also, this will sound like an ignorant question - I am very new to Power BI and have been working from other people's reports, so I have zero training on how Power BI works. (And some very limited PowerQuery experience.)

 

When I followed your instructions, Power BI opened up the Transform Data window, and it does have a new query that lists all the Tables in that file. (Awesome!)

 

But now how am I supposed to get those in as source for my data? Do I have to code the query in?

 

 

DataInsights's avatar
DataInsights
Super User
2 years ago

jcmayernik,

 

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.

  • jcmayernik's avatar
    jcmayernik
    Regular Visitor
    2 years ago

    Thanks again!