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 other tables and the same error. I can see the table on preview but during load, it gives me this error. This one reads up to 7000 rows and throws this error.

 

 
Need Help

5 Replies

  • 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 Joey,

      This did not work. It read around 8172 rows and then gives the error.

       

      Regards,

       

      Jijoy

       

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