Using a Google Maps Concept

Hi, I am fairly new to Power BI and was looking for some help/advice.

I have connected directly to Google Bigquery successfuly and have pulled in the required tables I need. I have a issue whereby all the data is being pulled into Power BI which is now 47million rows of data. Is there way to only call the data I need same as you would using Google Maps. Google Maps will only bring back the data you search for rather than all the rows. Is there a way I can use the same concept using Power BI connected to Bigquery. pulling in 47million rows now crashes and it doesnt have the capacity to save the data. I dont not have any other databases like Azure.