Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

Power BI

Hello All!


I have a question in Power BI, How can I  Select 20 Tables of source data from 100 Tables? 

Community Support
Community Support

Hi @Mangesh_Palwade 

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.


Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

New Member

My source data is an Excel file & I want to start with 20 tables.

Right, are they in one file or is it multiple files? If it's one file, you should see something like this when you open.



If it's multiple files, you can connect to folder(s) the files are in and then select which files to import in power query

Solution Sage
Solution Sage



Where is your source data coming from? (SQL, csv, Excel...)

Have you already imported all 100 tables or you need to remove some or do you just want to start with the 20?


Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors