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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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.