Forum Discussion

Heinrich's avatar
Heinrich
Post Partisan
2 years ago
Solved

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
Heinrich

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • AnalyticPulse's avatar
    AnalyticPulse
    2 years ago

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

     

14 Replies

  • AnalyticPulse's avatar
    AnalyticPulse
    Solution Sage
    2 years ago

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

    • Heinrich's avatar
      Heinrich
      Post Partisan
      2 years ago

      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

      • AnalyticPulse's avatar
        AnalyticPulse
        Solution Sage
        2 years ago

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

         

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    2 years ago

    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.

     

  • AUDISU's avatar
    AUDISU
    Resolver III
    2 years ago

    HI Heinrich ,

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

    Thanks