Can't connect to Google Sheet from Desktop after setting up Scheduled Refresh

[sfelwy2]

Hi!

This morning, I clicked the refresh button and got this error message. "The underlying connection was closed: An unexpected error occurred on a send."

Due to this error, new data couldn't be fetched from Google Sheets.

The day before, I did set up a scheduled refresh.

Do you know if this scheduled refresh causes the issue at Power BI Desktop? 

Since the scheduled refresh still works, I'm leaving it as is and not removing it but how can I get the Desktop's refresh data to work again?

Thank you in advance for any help/comments offered.

[v-yiruan-msft]

Hi  @sfelwy2 ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[sfelwy2]

Thanks for your replies. However, I'm still facing the issue.

I proceeded to reinstall Microsoft Power BI Desktop and am facing another issue which I believe is related to the earlier problem.

Basically, I'm unable to sign in. After entering my email address and clicking on Continue, the pop-up disappears, but there isn't a pop-up requesting a password.

I tried installing Power BI Desktop on another laptop and tried to sign in without any problems.

Any ideas what could have caused the authentication pop-up to not kick in?

Thanks!

[v-yiruan-msft]

Hi @sfelwy2 ,

The following minimum requirements need to fulfilled when run Power BI Desktop in your computer or laptop, you can find more details in this official documentation. Please note that Power BI Desktop is no longer supported on Windows 7.

• Windows 8.1 / Windows Server 2012 R2, or later
• .NET 4.6.2 or later
• Internet Explorer 11 or later
• Memory (RAM): At least 2 GB available, 4 GB or more recommended.
• Display: At least 1440x900 or 1600x900 (16:9) required. Lower resolutions such as 1024x768 or 1280x800 aren't supported, as certain controls (such as closing the startup screen) display beyond those resolutions.
• Windows display settings: If you set your display settings to change the size of text, apps, and other items to more than 100%, you may not be able to see certain dialogs that you must interact with to continue using Power BI Desktop. If you encounter this issue, check your display settings in Windows by going to Settings > System > Display, and use the slider to return display settings to 100%.
• CPU: 1 gigahertz (GHz) 64-bit (x64) processor or better recommended.
• WebView2, if not automatically installed with Power BI Desktop or uninstalled. Download and run the installer for WebView2.

So please check whether the laptop which connect to Google sheet get failed has met the above requirements, and please confirm whether another laptop which can sign in normally can connect to Google sheet successfully in Power BI Desktop? Thank you.

Best Regards

[amitchandak]

@sfelwy2 , In the refresh page shown above, edit credentials and provide them again. Manually refresh and check once

[sfelwy2]

Dear Amit,

Thanks for your reply.

Yes, your suggestion works as it's within https://app.powerbi.com/

In fact, the Scheduled Refresh runs fine according to the refresh history.

The part I'm facing an issue with is from Power BI Desktop, screenshot error below.

Any idea why the data source connection to Google Sheets would return this error?

Thanks!

[v-yiruan-msft]

Hi @sfelwy2 ，

Please select the options File --> Options and settings--> Data source settings and edit the credentials of the data source. Later check if it can work...

Manage data source credentials in Power Bi Desktop and Power Bi Server

Edit permission

To clear the Data Source Settings Cache

Best Regards