Forum Discussion

hbarber's avatar
hbarber
Regular Visitor
8 years ago

PowerBI desktop - New version cannot refresh reports

Hi there,   My colleague and I have different version of PowerBI Desktop and she is able to refresh reports (without the error message below)and I am not. She has version Version: 2.52.4921.682 64...
Need Help
v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi hbarber,

 

Since the error said that Conversion failed when converting date and/or time from character string.

 

As you were refreshing reports, have you verified that if there exists none datetime type data in the date /or time column?

 

=> However when I click through the steps in the query it is not necessarily at a point where I am bringing dates into the data that this error message appears.

 

When the error appears, what's the data here?

 

Thanks,
Xi Jin.

hbarber's avatar
hbarber
Regular Visitor
8 years ago

Thank you for your quick reply.

 

It turns out there is an issue with the date/time set up on my profile compared to my colleague's hence why she is able to use PBI and I am not.

 

All sorted now!

 

Thanks

Harriet

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi ,

    I am getting this below error when i try to load the Calendar View from SQL DW

    DataSource.Error: Microsoft SQL: Conversion failed when converting date and/or time from character string.
    Details:
    DataSourceKind=SQL
    DataSourcePath=xxx
    Message=Conversion failed when converting date and/or time from character string.
    Number=241
    Class=16

     

    can you please help to resolve it

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I have the same problem, any solution?