Forum Discussion

umerzaid's avatar
umerzaid
Frequent Visitor
4 years ago
Solved

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 Ho...
Need Help
  • umerzaid's avatar
    umerzaid
    4 years ago

    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
amitchandak's avatar
amitchandak
Super User
4 years ago

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

umerzaid's avatar
umerzaid
Frequent Visitor
4 years ago

I did try that but I got the same error