how/where to find Path Exploration data from GA4 in PowerBI

[usman1]

i am using Google Analytics 4 data in my powerBI reports. 

I can connect and import the data into powerbi.
but where can i find the Path Exploration Data from which i can create the Path Exploration Report?
Thank you in advance

[ReportGuru · Accepted solution]

Hi @usman1  As the 2.0 connector is still in beta I would recommend you use a workaround for your connection, maybe you can try to test your connection with a 3rd party tool. I currently use windsor.ai to connect my GA4 data and it provides access to event data, including event_name, page_path, and event_timestamp, among others, which will help you build a path exploration report. 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 you can select relevant fields for Path Exploration (such as event_name, page_path, session_id, user_id, event_timestamp)

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.