Forum Discussion

neetu14's avatar
neetu14
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

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

Getting datatype mismatch error when refreshing the report on Power BI Service. datatype in SQL source table is nvarchar whereas in power bi desktop it is a decimal number (which is what I need for ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

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

     

neetu14's avatar
neetu14
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Thanks for your reply. Is there a way to replace the 'NAN' value with 0 for future records?

 

For example, what if the data being refreshed tomorrow has the same value, can it be automatically replaced with 0 and report is refreshed without any issues.

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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

 

  • efratf's avatar
    efratf
    New Member
    1 year ago

    In my case it was due to new column added (from SQL) to one of the tables used in the report (imported), once I refreshed the table from PowerBi Desktop and published the report the error was solved.