Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
The client use Google Analytics 4, and when I try to use the GA connector in Power BI, sites are not showing in the list of websites. It seems to affect sites that don't have a UA number in Google Analytics. There is one account with several Properties&Apps without UA. When I get data in Power BI I get "The key didn't match any rows in the table" error.
I haven't been able to find anything via Google. Has anyone had a similar issue and worked out how to solve it?
Earlier we've used script below before upgrade to GA 4 (result was ok):
let
Source = GoogleAnalytics.Accounts(),
#"<ID>" = Source{[Id="<ID>"]}[Data],
#"UA-<ID>-1" = #"<ID>"{[Id="UA-<ID>-1"]}[Data],
#"<View ID>" = #"UA-<ID>-1"{[Id="<View ID>"]}[Data],
#"Added Items" = Cube.Transform(#"<View ID>",
{
{Cube.AddAndExpandDimensionColumn, "ga:source", {"ga:source"}, {"Source"}},
{Cube.AddMeasureColumn, "Users", "ga:users"}
})
in
#"Added Items"
Many thanks in advance!
Solved! Go to Solution.
Hi, @SisterRay
This may be a compatibility issue, you may need to contact the Microsoft Support Team to confirm this incident.
The Google Analytics connector in Power BI Desktop relies on the Google Analytics Core Reporting API. As such, features and availability may vary over time. Although the development team attempts to release updates in accordance with any changes, the API may change in a way that affects the results of the queries . In some cases, certain queries may no longer be supported. Due to this dependency, the results of your queries are not guaranteed when using this connector.
You can refer to this document about the Limitations and issues.
Best Regards,
Community Support Team _ Eason
Hi, now you have the 2.0 beta connector which is compatible with GA4 data but that one still have some issues sometimes with the data. As a workaround, maybe you can try to test your connection with a 3rd party tool. 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.
Hi if you're still looking for a solution this migth help: https://cooriedug.com/custom-ga4-power-bi-connector-setup/
I'm having the same issue here. Google just announced they will sunset Universal Analytics (UA) in 2023. We hope The Power BI team at Microsoft will look into the solution soon.
Hi, @SisterRay
This may be a compatibility issue, you may need to contact the Microsoft Support Team to confirm this incident.
The Google Analytics connector in Power BI Desktop relies on the Google Analytics Core Reporting API. As such, features and availability may vary over time. Although the development team attempts to release updates in accordance with any changes, the API may change in a way that affects the results of the queries . In some cases, certain queries may no longer be supported. Due to this dependency, the results of your queries are not guaranteed when using this connector.
You can refer to this document about the Limitations and issues.
Best Regards,
Community Support Team _ Eason
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |