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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Impactful Individual
Impactful Individual

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.