If my prediction is correct-
You have a single spread sheet with data from several categories.
You wish to import all of your data into Power BI.
However, each category will require its own sheet.
You can get your desired data sets in Power BI by following the steps below:
Set the sheet to power bidding mode.
Duplicate your data set as many times as you wish, depending on the number of data sets you have.
Remove all columns from all data sets except the ones you need in the current data collection.
This should give you the data sets you want in power bi.