BigQuery Automatic Import

[paybacksilver]

I've been trying to import Google Analytics data for the last few weeks - according to a few sources I've found, Google Analytics 4 is not compatible with the Power BI connector and has to be imported into Google's BigQuery daily as a json document of individual actions. 

This isn't a big deal for me, but I'm facing issues importing the data from BigQuery to PowerBI:

The two issues I'm facing:

- Retrieving new files automatically (if April 4ths was uploaded, Power BI would not recognize it as I've only checked up to April 3rd.)

- Combining files (loading each of the "events" data tables leaves me with this:

Any help is appreciated, thanks!

[ReportBuilder07]

Hi @paybacksilver In this case, I would rather prefer to go directly from GA4 to PBI using a direct 3rd party connector. That's what I currently do and it saves me a lot of time. I've tried windsor.ai, supemetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the GA4 connector in the data sources list:

After that, just grant access to your GA4 account using your credentials, then on preview and destination page you will see a preview of your GA4 fields:

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

[v-easonf-msft]

Hi, @paybacksilver 

Please check if the solution in this thread.

Importing and merging multiple Google BigQuery tables 

Best Regards,
Community Support Team _ Eason