Forum Discussion

rmechoor's avatar
rmechoor
Frequent Visitor
1 year ago
Solved

Cannot connect to google accounts through google sheets connector

I can no longer connect to my google account through google sheets connector. Reports that were pulling data from google sheets stopped updating about 3 weeks ago. I am also unable to create any new connections to google sheets.

A popup asks me to connect to the google account. WHen I click Sign in, the "Something went wrong" error message pops up. See below screenshots.

 

I tried reinstalling PowerBI desktop, but the issue persists. Anyone know of any solutions? 

 

 

 

  • Hi rmechoor ,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thanks for reporting this, this is a known issue with the Google Sheets connector in power bi desktop. It started appearing from around mid june 2025. Here the sign in process is failing because of the changes in the Google's authentication flow and getting the error.

    An official fix has not yet been released but a quick workaround is like, if the report is published to the service, go to the dataset settings and under the Data source credentials, re authenticate the google sheets connection, refresh works here.

     

    And also I recommend submitting your detailed feedback and ideas through Microsoft's official feedback channels. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.

    Fabric Ideas - Microsoft Fabric Community

     

    Thanks and regards,

    Anjan Kumar Chippa

  • Hi Anjan,

     

    I finally fixed the issue by going with the nuclear option. I did a full system reset using the reset windows option. Wiped out all installed programs and settings while keeping my files. This fixed the issue. 

     

    Thanks for you rhelp on this!!

10 Replies

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support

    Hi rmechoor ,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thanks for reporting this, this is a known issue with the Google Sheets connector in power bi desktop. It started appearing from around mid june 2025. Here the sign in process is failing because of the changes in the Google's authentication flow and getting the error.

    An official fix has not yet been released but a quick workaround is like, if the report is published to the service, go to the dataset settings and under the Data source credentials, re authenticate the google sheets connection, refresh works here.

     

    And also I recommend submitting your detailed feedback and ideas through Microsoft's official feedback channels. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.

    Fabric Ideas - Microsoft Fabric Community

     

    Thanks and regards,

    Anjan Kumar Chippa

    • rmechoor's avatar
      rmechoor
      Frequent Visitor

      PowerBI desktop version is still not fixed, but I as able to use the published service. Will temporarily ue this for the report. Hope the desktop version is fixed soon.

       

      Thanks for your help!

    • rmechoor's avatar
      rmechoor
      Frequent Visitor

      Hi Anjan,

       

      Do you know if this error was ever fixed? I still ahve the same issue on PowerBI Desktop. Online report is stil updating, but I cannot make any meaningful changes to the report structure without the desktop version.

      • v-achippa's avatar
        v-achippa
        Icon for Community Support rankCommunity Support

        Hi rmechoor,

         

        Thank you for checking back. As of now this issue is not fully fixed in power bi desktop. The google sheets connector sign in failure is a known ongoing issue related to google OAuth changes.

        Unfortunately, there is no supported workaround and there is no ETA yet, but I recommend keeping power bi desktop up to date and following the fabric ideas or release notes for updates on this connector.

         

        Thanks and regards,

        Anjan Kumar Chippa

  • Hi rmechoor 

    Unfortunately, the error message shown here ("Something went wrong") doesn’t include specific technical details, so we can only make a few educated guesses and test possible solutions:

    1. Google Account Permissions: It’s possible that something changed in the permissions associated with your Google account. Power BI Desktop may no longer have access to your Google Sheets due to updated security policies or revoked consent. Try the following:

      • Go to your Google Account → Security → Third-party apps with account access → Remove Power BI if listed.

      • Then, open Power BI Desktop again and reconnect to Google Sheets to re-authorize access.

    2. Power BI Desktop Version: If you recently updated or reinstalled Power BI Desktop, it’s possible the Google Sheets connector behavior changed. In this case:

      • Uninstall your current version of Power BI Desktop completely.

      • Reinstall the latest version from the official Microsoft site.

      • Alternatively, try an older version (available from the Microsoft Download Center) to check if the issue is version-specific.

    3. Browser/Network Issues: Power BI relies on your default browser for OAuth authentication. If there's a misconfiguration, outdated cookies, or browser extensions interfering:

      • Try setting your default browser to Edge or Chrome (whichever wasn’t used before).

      • Clear cache and cookies.

      • Ensure no browser extensions (especially ad-blockers or privacy tools) are interfering.

    4. IT/Network Restrictions: If you're on a managed device or behind a corporate firewall or VPN, security restrictions might be blocking the OAuth redirect. Try disconnecting from VPN or using a personal network to test.

    5. Check Google Workspace Admin Settings (if applicable): If you're using a Google Workspace account, the admin may have restricted third-party OAuth connections. Ask your admin to review any recent changes.

    If none of the above works, I recommend opening a ticket with Microsoft Power BI support and/or checking with Google support to verify if there are known changes to the OAuth handling or API access.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

    • rmechoor's avatar
      rmechoor
      Frequent Visitor

      Ritaf1983 

      Let me know if below details provide any helpful info 

       

       

       

       

       

      Feedback Type:
      Frown (Error)

      Timestamp:
      2025-12-30T20:46:29.9557756Z

      Local Time:
      2025-12-30T14:46:29.9557756-06:00

      Session ID:
      91237dc5-1e11-4c1e-8464-5f03484b94d0

      Release:
      November 2025

      Product Version:
      2.149.1429.0 (25.11)+bde538da1131949e2404b2eefbc12fe5cf1882b0 (x64)

      Stack Trace:
      Microsoft.Mashup.Host.Document.JavaScriptException
      Error
      at OAuthDialog.openOAuthDialog (ms-pbi://pbi.microsoft.com/ts/Editor/Challenges/OAuthDialog.js:20:13)
      at MsOnline._onMsOnlineSignInClick (ms-pbi://pbi.microsoft.com/ts/Editor/Challenges/MsOnline.js:39:17)
      at Anonymous function (ms-pbi://pbi.microsoft.com/ts/Shared/Button.js:27:21)
      at n.event.dispatch (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:3:7481)
      at r.handle (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:3:5547)

      PowerBINonFatalError:
      {"AppName":"PBIDesktop","AppVersion":"2.149.1429.0","ModuleName":"ms-pbi://pbi.microsoft.com/ts/Editor/Challenges/OAuthDialog.js","Component":"OAuthDialog","Error":"Error","MethodDef":"openOAuthDialog","ErrorOffset":"20:13","ErrorCode":""}

      OS Version:
      Microsoft Windows NT 10.0.26100.0 (x64 en-US)

      CLR Version:
      4.8 or later [Release Number = 533320]

      Peak Virtual Memory:
      88.1 GB

      Private Memory:
      1.14 GB

      Peak Working Set:
      1.01 GB

      IE Version:
      11.1882.26100.0

      User ID:
      8a2aa706-ed9b-4b5e-baae-c0397ed837e9

      Workbook Package Info:
      1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

      Telemetry Enabled:
      True

      Model Default Mode:
      Import

      Model Version:
      PowerBI_V3

      Enabled Preview Features:
      PBI_googleBigQueryAdbcVersionEnabled
      PBI_scorecardVisual
      PBI_setLabelOnExportPdf
      PBI_oneDriveSave
      PBI_oneDriveShare
      PBI_odspSaveBackgroundUpload
      PBI_modernOfficeFilePicker
      PBI_useModernPublishDialogs
      PBI_gitIntegration
      PBI_tmdlInDataset
      PBI_enhancedReportFormat
      PBI_directLakeOnOneLake
      PBI_advancedSlicerTypeList
      PBI_textSlicer
      PBI_aiNarrativesVisual
      PBI_visualCalculationsAuthoring
      PBI_copilotUnifiedTooling
      PBI_UserInstalledVerticaODBCDriver
      PBI_sqlDbNativeArtifactsOnDesktop
      PBI_dataFunctionActions
      PBI_enableExportQueries

      Disabled Preview Features:
      PBI_DatabricksAdbcVersionEnabled
      PBI_snowflakeLegacyOdbcVersionEnabled
      PBI_shapeMapVisualEnabled
      PBI_SpanishLinguisticsEnabled
      PBI_qnaLiveConnect
      PBI_metricsArtifactsOnDesktop
      PBI_b2bExternalDatasetSharing
      PBI_enhancedTooltips
      PBI_onObject
      PBI_publishDialogsSupportSubfolders
      PBI_enhancedReportFormatPBIX
      PBI_qnaImproveLsdlCopilot
      PBI_customCalendars
      PBI_UserInstalledNetezzaODBCDriver
      MashupFlight_EnableOracleBundledOdacProvider
      PBI_supportUDFs

      Disabled DirectQuery Options:
      TreatHanaAsRelationalSource

      Cloud:
      GlobalCloud

      DPI Scale:
      150%

      Supported Services:
      Power BI

      WebView2 Runtime Version:
      143.0.3650.96

      WebView2 SDK Version:
      1.0.2365.46