Using a Google Maps Concept

[PSRai]

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.

[v-juanli-msft]

Hi @PSRai 

I'm not sure if your scenario can be achieved.

Here are some references which you could check how to use Google map in Power BI.

https://www.linkedin.com/pulse/power-bi-google-maps-api-address-lookup-soheil-bakhshi

https://www.biinsight.com/power-bi-and-google-maps-api-address-lookup/

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.