Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Stardust1221
New Member

Problem connecting to Google Analytics

Hello Power BI Community,

 

I have an issue connecting to Google Analytics from Power BI. When I click Get Data->Google Analytics->Sign in, the browser window or pop-up does not appear on the screen for me to sign in. I have tried uninstalling and reinstalling Power BI and also clearing the browser cache but they dont work. 

 

I enbled trace logs and got the following traces regrading the problem:

 

DataMashup.Trace Information: 24579 : {"Start":"2023-11-13T10:58:06.1985224Z","Action":"OAuthDialogInfo","oAuthDialogType":"SystemBrowserOAuthDialog","userDataFolderIsEmpty":"False","resourceKind":"GoogleAnalytics","sessionId":"b81cbd84-475d-4ff8-b478-1b81dc4af154","deviceId":"d20cb926","userId":"7b16835a-dc02-429b-aa3f-ecf7d90766c8","isInternal":"False","authenticatedUserId":"151f74ca-aa06-4a22-b24d-f6b54f4d0bd8","ProductVersion":"2.122.746.0 (23.10)","ActivityId":"3e6430a3-6679-4b31-9807-570034325dde","Process":"PBIDesktop","Pid":3124,"Tid":1,"Duration":"-00:00:00.1208643"}
DataMashup.Trace Information: 24579 : {"Start":"2023-11-13T10:58:06.0744108Z","Action":"ModernBrowserOAuthDialogFactory/Create","resourceKind":"GoogleAnalytics","WebviewWindowFactory.IsRuntimeAvailable()":true,"userDataFolder":"C:\\Users\\neudorS\\AppData\\Local\\Microsoft\\Power BI Desktop","disableModernBrowserForAll":false,"modernBrowserResourceKindDenySet.Contains(resourceKind)":false,"systemBrowserResourceKinds.Contains(resourceKind)":true,"getUseSystemBrowserForAuthenticationSetting()":false,"disableSystemBrowserOAuth":false,"usesCookieBasedAuthentication":false,"ProductVersion":"2.122.746.0 (23.10)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":3124,"Tid":1,"Duration":"00:00:00.0033236"}
DataMashup.Trace Information: 24579 : {"Start":"2023-11-13T10:58:06.0777482Z","Action":"SystemBrowserOAuthDialog/Authorize","wrapperUrl":"https://oauth.powerbi.com/views/oauthredirect.html?login_uri=https%3a%2f%2faccounts.google.com%2fo%2... (23.10)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":3124,"Tid":1,"Duration":"00:00:00.0496839"}
DataMashup.Trace Error: 24579 : {"Start":"2023-11-13T10:58:06.1276640Z","Action":"UnexpectedExceptionHandler/HandleException","Exception":"Exception:\r\nExceptionType: System.Net.HttpListenerException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Das Netzwerkadresse ist nicht erreichbar. Weitere Informationen \u00FCber die Behebung von Netzwerkproblemen finden Sie in der Windows-Hilfe\r\nStackTrace:\n   bei System.Net.HttpListener.AddAllPrefixes()\r\n   bei System.Net.HttpListener.Start()\r\n   bei Microsoft.Mashup.Client.UI.Extensions.Windows.SystemBrowserOAuthDialog.Authorize(Uri logoutUri, Uri authorizationUri)\r\n   bei Microsoft.Mashup.Client.UI.Shared.OAuthManager.OpenOAuthDialog(IWindowHandle parentWindowHandle, ITelemetryService telemetryService, String resourceKind, String accessToken, String resourceUrl)\r\n   bei Microsoft.Mashup.Client.UI.Shared.OAuthManager.<>c__DisplayClass6_0.<OpenOAuthDialog>b__0()\r\n   bei Microsoft.Mashup.Client.UI.Shared.OAuthManager.<>c__DisplayClass7_0.<AsyncGetOAuthResult>b__0()\r\n   bei Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)\r\n\r\n\r\n","ProductVersion":"2.122.746.0 (23.10)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":3124,"Tid":1,"Duration":"00:00:00.0004369"}
DataMashup.Trace Error: 24579 : {"Start":"2023-11-13T10:58:06.1289868Z","Action":"PBI.Telemetry/LogUnhandledException Exception:System.Net.HttpListenerException (0x80004005): Das Netzwerkadresse ist nicht erreichbar. Weitere Informationen \u00FCber die Behebung von Netzwerkproblemen finden Sie in der Windows-Hilfe\r\n   bei System.Net.HttpListener.AddAllPrefixes()\r\n   bei System.Net.HttpListener.Start()\r\n   bei Microsoft.Mashup.Client.UI.Extensions.Windows.SystemBrowserOAuthDialog.Authorize(Uri logoutUri, Uri authorizationUri)\r\n   bei Microsoft.Mashup.Client.UI.Shared.OAuthManager.OpenOAuthDialog(IWindowHandle parentWindowHandle, ITelemetryService telemetryService, String resourceKind, String accessToken, String resourceUrl)\r\n   bei Microsoft.Mashup.Client.UI.Shared.OAuthManager.<>c__DisplayClass6_0.<OpenOAuthDialog>b__0()\r\n   bei Microsoft.Mashup.Client.UI.Shared.OAuthManager.<>c__DisplayClass7_0.<AsyncGetOAuthResult>b__0()\r\n   bei Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)","ProductVersion":"2.122.746.0 (23.10)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":3124,"Tid":1,"Duration":"00:00:00.0000199"}
DataMashup.Trace Critical: 24579 : {"Start":"2023-11-13T10:58:06.2543194Z","Action":"PBI.PQ.UnhandledException","message":"HttpListenerException Das Netzwerkadresse ist nicht erreichbar. Weitere Informationen \u00FCber die Behebung von Netzwerkproblemen finden Sie in der Windows-Hilfe","stackTrace":"HttpListenerException\r\n   at System.Net.HttpListener.AddAllPrefixes()\r\n   at System.Net.HttpListener.Start()\r\n   at Microsoft.Mashup.Client.UI.Extensions.Windows.SystemBrowserOAuthDialog.Authorize(Uri logoutUri, Uri authorizationUri)\r\n   at Microsoft.Mashup.Client.UI.Shared.OAuthManager.OpenOAuthDialog(IWindowHandle parentWindowHandle, ITelemetryService telemetryService, String resourceKind, String accessToken, String resourceUrl)\r\n   at Microsoft.Mashup.Client.UI.Shared.OAuthManager.<>c__DisplayClass6_0.<OpenOAuthDialog>b__0()\r\n   at Microsoft.Mashup.Client.UI.Shared.OAuthManager.<>c__DisplayClass7_0.<AsyncGetOAuthResult>b__0()\r\n   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)","OSBitness":"64-bit","OSVersion":"Microsoft Windows NT 10.0.19045.0","location":"","powerBINonFatalError":"{\"AppName\":\"PBIDesktop\",\"AppVersion\":\"2.122.746.0\",\"ModuleName\":\"Microsoft.Mashup.Client.UI.Extension.dll\",\"Component\":\"Microsoft.Mashup.Client.UI.Extensions.Windows.SystemBrowserOAuthDialog\",\"Error\":\"System.Net.HttpListenerException - 0x000004D0\",\"MethodDef\":\"Authorize\",\"ErrorOffset\":\"133\",\"ErrorCode\":\"\"}","stackTrace2":"","stackTrace3":"","stackTrace4":"","modelTraits":"{\"importTables\":0,\"directQueryTables\":0,\"dualTables\":0,\"directLakeTables\":0,\"directQuerySources\":0,\"proxyModelSources\":0,\"mashupEvaluatedCubeSources\":0,\"directLakeSources\":0}","hresult":"0x80004005)","sessionId":"b81cbd84-475d-4ff8-b478-1b81dc4af154","deviceId":"d20cb926","userId":"7b16835a-dc02-429b-aa3f-ecf7d90766c8","isInternal":"False","authenticatedUserId":"151f74ca-aa06-4a22-b24d-f6b54f4d0bd8","ProductVersion":"2.122.746.0 (23.10)","ActivityId":"95691936-2717-434d-a871-1ec771ff6b26","Process":"PBIDesktop","Pid":3124,"Tid":1,"Duration":"-00:00:00.1212362"}

 

Could anyone help interpret the issue from these logs?

I kindly request the community to support solving this issue. 

 

1 REPLY 1
QueryWhiz
Helper V
Helper V

Hi @Stardust1221 were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector. 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 GA connector in the data sources list:

 

GA-1.png

 

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

 

GA-2.png

 

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.

 

SELECT_DESTINATION_NEW.png

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.