Forum Discussion

jijoyav's avatar
jijoyav
Frequent Visitor
6 years ago

Power BI - ODBC error

Hello, Its been a while since I used ODBC to connect to my data source. Today when I tried i get the below error. I do not get any error when I try to load smaller tables. I have tried with a few ot...
Need Help
v-joesh-msft's avatar
v-joesh-msft
Solution Sage
6 years ago

Hi jijoyav ,

Try to disable the option and try again:

Best Regards,

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

jijoyav's avatar
jijoyav
Frequent Visitor
6 years ago

Hello,

I have looked at the DB and found that there are non-english characters in the table. This might be the reason the data does not get pulled. This DB is UTF enabled. Is tehre a way to pull non-english characters?

  • v-joesh-msft's avatar
    v-joesh-msft
    Solution Sage
    6 years ago

    Hi jijoyav ,

    Referring to the following post, you may need to find the appropriate column and manually define the character encoding:

    Non-english characters not importing properly

    Best Regards,

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

    • jijoyav's avatar
      jijoyav
      Frequent Visitor
      6 years ago

      Hello,

       

      I have referred the link but how do I manually add encoding to the column? Where do i find the encoding from?