Forum Discussion

sheetals's avatar
sheetals
Helper I
4 years ago

Error while connecting to teradata database in directquery mode

Hi all,

I have connected Teradata database with directQuery mode to power bi and when I load the data It shows me the below error:

Key cannot be null. Parameter name: key.

 

Whereas In import mode there is no such error caused

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi sheetals ,

     

    Here're some requirements for your confirmation:

    1.Power BI Desktop is the latest version.

    2.Both the server name and data name are filled in correctly.

    Also, as a workaround, you can try doing

    File -> Options and settings -> Options -> Data Load (under global) -> Folded artifacts cache options -> clear cache

    This should clear and regenrate the cache. (the error occurs when trying to read the cache.)

     

     

     

    Best Regards,

    Stephen Tao

     

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

    • sheetals's avatar
      sheetals
      Helper I
      4 years ago

      Anonymous  I have cross checked the 3 requirements mentioned and all are correct  and up to date still it throws up same error. 

      It works well with import mode

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi sheetals ,

         

        Since I cannot reproduce your problem, I think you can contact the support team for help:

        Support | Microsoft Power BI

         

        Best Regards,

        Stephen Tao

         

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