Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
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.
Solved! Go to 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.
This helped me a lot https://learn.microsoft.com/en-us/power-query/connectors/googlebigquery to use wildcard SQL
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.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 63 | |
| 52 | |
| 41 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 124 | |
| 108 | |
| 47 | |
| 28 | |
| 27 |