Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

issues with casted column

Hello,

 

I would like to import data from sql. In one column I have casted nvarchars to numbers in sql without receiving an error message, but when I try to import the data into power bi, it says "invalid number". Does Power BI have trouble with casted numbers? Can you help me to overcome this issue?

 

Thanks,

Susanne

Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You could import the original data ( nvarchar type ) and check if error occurs. After my tests, it works properly.

     

3 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    You could import to Power BI at first and use UNICODE() function to get the correct results.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hey v-eachen-msft ,

       

      thanks for your reply. 

      My problem is, that I can't even import the data set since I already get the error message while loading it into power bi, so I can't change anything in it. 

      Can you help me with this?

       

      Kind regards,

      Susanne

      • v-eachen-msft's avatar
        v-eachen-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        You could import the original data ( nvarchar type ) and check if error occurs. After my tests, it works properly.