Data refresh

[Todd1621]

Hello very new to power BI. I updated the credetials so i could refresh it but now that i have my refresh fails and gives me this error code. Any ideas? thank you 

[Anonymous · Accepted solution]

Hi @Todd1621 

You can refresh data in Desktop , but when you refreshed data in Service , it failed and returned an error , right ?

This error could be an issue with your M script within your Power BI Desktop file.

Why refresh works in Power BI Desktop but not in Service, It may for the date conversions are handled differently in the Power BI Service, and the Power BI Service is not tolerant of an invalid date. 

As a temperary solution, you could refresh the PBIX in Desktop and re-upload the file to the Service.

Or you could check the column data types in the data model and data source and ensure that the data types are compatible. 

I have also found a similar post, please refer to it to see if it helps you.

Type mismatch - Unable to convert a value to the data type requested 

• right-click the colum and use Replace Values. In Query Editor

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Todd1621 

You will need to revisit your pbix as you can see from the error that there are some data type issues in your report.

Please get that resolved and post that you'll be able to refresh.