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 ...
Need Help
  • v-achippa's avatar
    v-achippa
    1 year ago

    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
    7 months ago

    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!!

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
1 year ago

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
    8 months ago

    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