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 "...
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.

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity 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
      Icon for Community Support rankCommunity 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.