GA4 Data not shwoing in BQ

12 views
Skip to first unread message

Besserwisser Skript

unread,
Jun 20, 2025, 4:07:44 AMJun 20
to Instant BQML and Vertex Users
Hello,
I am trying to set up my second BQML Project. (The first one worked)
I am not seeing any Data in BigQuery even though, I have setup the Linking in GA4 according to this article: https://support.google.com/analytics/answer/9823238?hl=en#step2&zippy=%2Cin-this-article

I will note what I did here:
1.Create Cloud Project with Billing and enable BQ API
2.Link GA4 to the Project
Screenshot 2025-06-20 100705.png
3. Review Permissions
Screenshot 2025-06-20 100354.png

The analytics Mail adress has set up the GA4 Linking.

What am I doing wrong?

Best,
Jan

Besserwisser Skript

unread,
Jun 23, 2025, 5:51:11 AMJun 23
to Instant BQML and Vertex Users
I have just verified, that the service-account has access to GA4 via Cloud Shell like so:
from google.analytics.data_v1beta import BetaAnalyticsDataClient
from google.analytics.data_v1beta.types import RunReportRequest, DateRange, Metric, Dimension

client = BetaAnalyticsDataClient.from_service_account_file("key.json")

property_id = "YOUR-GA4-PROPERTY-ID"

request = RunReportRequest(
    property=f"properties/{property_id}",
    dimensions=[Dimension(name="country")],
    metrics=[Metric(name="activeUsers")],
    date_ranges=[DateRange(start_date="7daysAgo", end_date="today")],
)

try:
    response = client.run_report(request)
    print("✅ Success! You have access.")
    for row in response.rows:
        print(row)
except Exception as e:
    print("❌ Failed. Error was:")
    print(e)

which ran successfully. I am also seeing the expected Dataset in BQ but its just empty.

Besserwisser Skript

unread,
Jun 25, 2025, 5:52:09 AMJun 25
to Instant BQML and Vertex Users
I have switched the export to Daily/Streaming from Daily only , now the Data suddenly appears.
Reply all
Reply to author
Forward
0 new messages