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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
umerzaid
Frequent Visitor

Google Sheets Refreshing Issue

Dear Experts,

I have a Power BI dashboard on Power BI Desktop connecting to 9 to 10 Google sheets. Each day the sheets are updated on Google sheets and and normally, I use the refresh button on Home tab (next to transform data) which updates the dashboard and was working fine. At that time I haven't installed the May 2022 and was using the Google Sheets beta connector. Today I installed the update and now when I use that refresh button, I am getting error messages. The only weird thing for me is that the refresh button in Power Query Editor is not having any issues. Please guide me how to find source of issue or how to rectify it.

 

I also cannot share the file so please do not ask

The messages I get when refreshing from Home tab in Power BI desktop:

 

umerzaid_0-1654520065116.png

 

Sales 2022
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
 
_MeasureTable
Load was cancelled by an error in loading a previous table.
 
_Calender
Load was cancelled by an error in loading a previous table.
 
Procurement 2022
Load was cancelled by an error in loading a previous table.
 
Return 2022
Load was cancelled by an error in loading a previous table.
 
Removal Order 2022
OLE DB or ODBC error: [DataFormat.Error] We couldn't parse the input provided as a DateTimeZone value..
 
Removal Shipment 2022
Load was cancelled by an error in loading a previous table.
 
Sales 2021
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
 
Channel_LT
Load was cancelled by an error in loading a previous table.
 
Brands & Suppliers
Load was cancelled by an error in loading a previous table.
 
Return 2022 (C)
Load was cancelled by an error in loading a previous table.
 
Procurement 2022 (C)
Load was cancelled by an error in loading a previous table.
 
I-22
Load was cancelled by an error in loading a previous table.
 
RMT - Seattle
Load was cancelled by an error in loading a previous table.
 
I-22 (C)
Load was cancelled by an error in loading a previous table.
 
RMT - Seattle (C)
Load was cancelled by an error in loading a previous table.
 
Reserve 2022
Load was cancelled by an error in loading a previous table.

 

Ive tried clearing the permission from data source settings as well clearing all table relationship in model view but niether succeeded.

 

Also below is the table relationship for refernce

 

umerzaid_2-1654520370333.png

 

1 ACCEPTED SOLUTION

Issue resolved

Removal Order 2022
OLE DB or ODBC error: [DataFormat.Error] We couldn't parse the input provided as a DateTimeZone value..

The above table was the culprit. After deleting it, the refresh is now successful

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@umerzaid , I checked issues, and I do not see any issue reported like that

 

Try this first

Home Tab-> Transform data -> edit data source -> Select datasource and clear premission.

 

Provide credentials and try again

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

I did try that but I got the same error

Issue resolved

Removal Order 2022
OLE DB or ODBC error: [DataFormat.Error] We couldn't parse the input provided as a DateTimeZone value..

The above table was the culprit. After deleting it, the refresh is now successful

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.