Since you’ve already tried recreating your data streams, the issues you’re encountering may be due to some other factors. One possibility might be related to permissions: ensure that each property is properly linked to BigQuery and that the BigQuery service account has permission to access and write data.

Another potential culprit might be how your datasets are organized in BigQuery. Google Analytics 4 (GA4) exports raw event data to BigQuery once a day under the dataset name that you’ve specified. If these datasets are not set up correctly or are inconsistent in some way, it may be causing complications.

Sometimes, data can be delayed for a few hours even under ideal conditions, but as you’ve waited a few weeks already, it seems unlikely to be a simple delay issue. You may want to reach out to GA4 or BigQuery’s support services or consult an expert in these areas.