Remove Data Source From Data Source. See Removing Data that You Added. Nevertheless you have more options - for example you could name your data sources and retrieve them from the query by name QuerydataSourceName use the occurrence parameter in QuerydataSourceTable and so on.
You can remove a data source if you no longer use it. But please take note that it will also clear your connections from. Right-click control-click on a Mac the data source at the top of the Data pane and select Close.
Alternatively you can clear all recent items from Report Builder Options Dialog File-Options.
Connect to the Excel table as a data source. Navigate to the DATA SOURCES tab. Im having to do this because when I change a data table I unable to get the change reflected in the data source by using refresh. To add or remove data sources and edit permissions go to Business Settings then Data Sources.