Firebase events data in Google Big Query without loading

[iqb]

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. 

[iqb]

This helped me a lot https://learn.microsoft.com/en-us/power-query/connectors/googlebigquery to use wildcard SQL

[v-rzhou-msft · Accepted solution]

Hi @iqb ,

As far as I know, you can add SQL statement in advance options to get data as you want from Google Big Query.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.