Firebase events data in Google Big Query without loading

In Google Data Studio we can create data sources which are simple SQLs that run on run time to show data in charts.

For example, showing scorecard we write,

```

SELECT
event_date, event_name, UPPER(device.operating_system) AS Platform, app_info.firebase_app_id, geo.country AS Country,
FROM `analytics_xxx.events_*` WHERE event_name = 'first_open'

```

On runtime the dasboard load data from Google Big Query and show it on dashboard in Google Data Studio. Is it possible the same in Power BI? It look like Power BI always ask to load all data and I cannot load the data because table names are dynamic in Firebase and we have huge data.