cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hbarber Frequent Visitor
Frequent Visitor

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-bit (November 2017) and I have Version: 2.56.5023.942 64-bit (March 2018).

 

I used to have no issues and this has also caused our published reports to fail in refreshing daily.

 

This is the error message:

 

DataSource.Error: Microsoft SQL: Conversion failed when converting date and/or time from character string.
Details:
    DataSourceKind=SQL
    DataSourcePath=bb-svr-sql01;CRS_FIR1072
    Message=Conversion failed when converting date and/or time from character string.
    Number=241
    Class=16

 

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.

 

Any assistance would be greatly appreciated.

 

Thanks

Harriet

4 REPLIES 4
v-xjiin-msft Super Contributor
Super Contributor

Re: PowerBI desktop - New version cannot refresh reports

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 Frequent Visitor
Frequent Visitor

Re: PowerBI desktop - New version cannot refresh reports

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
Not applicable

Re: PowerBI desktop - New version cannot refresh reports

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

atellez New Member
New Member

Re: PowerBI desktop - New version cannot refresh reports

I have the same problem, any solution?

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 140 members 1,491 guests
Please welcome our newest community members: