Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Heinrich
Post Patron
Post Patron

Delete 1 Table from Source

Hello

I have imported an Excel into Power BI.

This Excel had originally 2 Tables.
How can I delete 1 Table without having to reimport the Workbook.

Regards
HeinrichPower_BI_Report.png

1 ACCEPTED SOLUTION

what about  navigation option below source? you get checkbox to select tabel there? after clicking on gear icon

AnalyticPulse_0-1711524070846.png

 

View solution in original post

14 REPLIES 14
AUDISU
Resolver III
Resolver III

HI @Heinrich ,

Click the filter button in the Name column. then slect the one you want.

AUDISU_0-1711445310346.png

Thanks

Idrissshatila
Super User
Super User

Hello @Heinrich ,

 

as long as you're not using it, then it won't effect deleting or keeping it because you're navigating through the sheet you want.

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




AnalyticPulse
Continued Contributor
Continued Contributor

click on setting icon of source and then uncheck the table that is not required

Hello 
I have looked at "Data Source Settings" but I do not have a possibility to check/uncheck tables.

Could you please add a printscreen where the possibility is shown how to choose a table.
Regards
Heinrich

can you check the gear icon nect to source option inn setting:

AnalyticPulse_0-1711448012982.png

 

Hello
Yes but I do not have the possibility to uncheck one table.
Regards
HeinrichSource_setting.png

what about  navigation option below source? you get checkbox to select tabel there? after clicking on gear icon

AnalyticPulse_0-1711524070846.png

 

can you check advance option? 

Hello
Yes I did. But no possibility.
Regards
Heinrich

Hi @Heinrich ,
Check my previous reply.
Thanks

Hello
I wanted to try "AnalyticPulse" solution.
Is that not possible?
Regards
Heinrich

Hi @Heinrich ,
What do you mean?
Thanks

Hello @AUDISU 

AnalyticPulse proposed a solution Re: Delete 1 Table from Source - Microsoft Fabric Community

and I would like to try this.

Regards

Heinrich

ryan_mayu
Super User
Super User

@Heinrich 

try to filter out one table. Then do the rest steps





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.